GET https://www.servicioseducativosnaku.com.mx/admin/orders/view/870

Query Metrics

33 Database Queries
7 Different statements
10.13 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.57 ms
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.mobile AS mobile_7, t0.position AS position_8, t0.is_active AS is_active_9, t0.updated_at AS updated_at_10, t0.created_at AS created_at_11, t0.photo AS photo_12, t0.address AS address_13 FROM users t0 WHERE t0.id = ?
Parameters:
[
  4
]
2 0.46 ms
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.items AS items_3, t0.subtotal AS subtotal_4, t0.tax AS tax_5, t0.total AS total_6, t0.is_active AS is_active_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.initial_payment AS initial_payment_10, t0.payments_start_date AS payments_start_date_11, t0.contract_number AS contract_number_12, t0.delivery_date AS delivery_date_13, t0.payment_amount AS payment_amount_14, t0.status AS status_15, t0.print AS print_16, t0.source AS source_17, t0.discount AS discount_18, t0.discount_by_agreement AS discount_by_agreement_19, t0.payment_type AS payment_type_20, t0.client_id AS client_id_21, t0.vendor_id AS vendor_id_22, t0.sales_closer_id AS sales_closer_id_23, t0.speaker_id AS speaker_id_24, t0.coordinator_id AS coordinator_id_25, t0.leader_id AS leader_id_26, t0.route_id AS route_id_27, t0.debt_collector_id AS debt_collector_id_28, t0.warehouse_id AS warehouse_id_29, t0.created_by_id AS created_by_id_30, t0.voucher_id AS voucher_id_31 FROM orders t0 WHERE t0.id = ?
Parameters:
[
  870
]
3 0.51 ms
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.motherslastname AS motherslastname_4, t0.is_active AS is_active_5, t0.updated_at AS updated_at_6, t0.created_at AS created_at_7, t0.photo AS photo_8, t0.official_id AS official_id_9, t0.home_exterior_photo AS home_exterior_photo_10, t0.created_by_id AS created_by_id_11 FROM clients t0 WHERE t0.id = ?
Parameters:
[
  871
]
4 0.57 ms
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.amount AS amount_3, t0.payment_date AS payment_date_4, t0.expiration_date AS expiration_date_5, t0.is_active AS is_active_6, t0.updated_at AS updated_at_7, t0.created_at AS created_at_8, t0.status AS status_9, t0.sort AS sort_10, t0.print AS print_11, t0.folio AS folio_12, t0.capture_date AS capture_date_13, t0.type AS type_14, t0.orders_id AS orders_id_15, t0.captured_by_id AS captured_by_id_16 FROM payments t0 WHERE t0.orders_id = ?
Parameters:
[
  870
]
5 0.41 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.thumb_filename AS thumb_filename_3, t0.type AS type_4, t0.category AS category_5, t0.folder AS folder_6, t0.clients_id AS clients_id_7, t0.payments_id AS payments_id_8, t0.partial_payments_id AS partial_payments_id_9 FROM media t0 WHERE t0.payments_id = ?
Parameters:
[
  11094
]
6 0.29 ms
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.created_at AS created_at_3, t0.amount AS amount_4, t0.folio AS folio_5, t0.status AS status_6, t0.type AS type_7, t0.payment_id AS payment_id_8, t0.captured_by_id AS captured_by_id_9 FROM partial_payments t0 WHERE t0.payment_id = ?
Parameters:
[
  11094
]
7 0.31 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.thumb_filename AS thumb_filename_3, t0.type AS type_4, t0.category AS category_5, t0.folder AS folder_6, t0.clients_id AS clients_id_7, t0.payments_id AS payments_id_8, t0.partial_payments_id AS partial_payments_id_9 FROM media t0 WHERE t0.payments_id = ?
Parameters:
[
  11095
]
8 0.36 ms
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.created_at AS created_at_3, t0.amount AS amount_4, t0.folio AS folio_5, t0.status AS status_6, t0.type AS type_7, t0.payment_id AS payment_id_8, t0.captured_by_id AS captured_by_id_9 FROM partial_payments t0 WHERE t0.payment_id = ?
Parameters:
[
  11095
]
9 0.31 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.thumb_filename AS thumb_filename_3, t0.type AS type_4, t0.category AS category_5, t0.folder AS folder_6, t0.clients_id AS clients_id_7, t0.payments_id AS payments_id_8, t0.partial_payments_id AS partial_payments_id_9 FROM media t0 WHERE t0.payments_id = ?
Parameters:
[
  11096
]
10 0.37 ms
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.created_at AS created_at_3, t0.amount AS amount_4, t0.folio AS folio_5, t0.status AS status_6, t0.type AS type_7, t0.payment_id AS payment_id_8, t0.captured_by_id AS captured_by_id_9 FROM partial_payments t0 WHERE t0.payment_id = ?
Parameters:
[
  11096
]
11 0.28 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.thumb_filename AS thumb_filename_3, t0.type AS type_4, t0.category AS category_5, t0.folder AS folder_6, t0.clients_id AS clients_id_7, t0.payments_id AS payments_id_8, t0.partial_payments_id AS partial_payments_id_9 FROM media t0 WHERE t0.payments_id = ?
Parameters:
[
  11097
]
12 0.26 ms
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.created_at AS created_at_3, t0.amount AS amount_4, t0.folio AS folio_5, t0.status AS status_6, t0.type AS type_7, t0.payment_id AS payment_id_8, t0.captured_by_id AS captured_by_id_9 FROM partial_payments t0 WHERE t0.payment_id = ?
Parameters:
[
  11097
]
13 0.25 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.thumb_filename AS thumb_filename_3, t0.type AS type_4, t0.category AS category_5, t0.folder AS folder_6, t0.clients_id AS clients_id_7, t0.payments_id AS payments_id_8, t0.partial_payments_id AS partial_payments_id_9 FROM media t0 WHERE t0.partial_payments_id = ?
Parameters:
[
  4714
]
14 0.25 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.thumb_filename AS thumb_filename_3, t0.type AS type_4, t0.category AS category_5, t0.folder AS folder_6, t0.clients_id AS clients_id_7, t0.payments_id AS payments_id_8, t0.partial_payments_id AS partial_payments_id_9 FROM media t0 WHERE t0.partial_payments_id = ?
Parameters:
[
  3054
]
15 0.23 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.thumb_filename AS thumb_filename_3, t0.type AS type_4, t0.category AS category_5, t0.folder AS folder_6, t0.clients_id AS clients_id_7, t0.payments_id AS payments_id_8, t0.partial_payments_id AS partial_payments_id_9 FROM media t0 WHERE t0.payments_id = ?
Parameters:
[
  11098
]
16 0.30 ms
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.created_at AS created_at_3, t0.amount AS amount_4, t0.folio AS folio_5, t0.status AS status_6, t0.type AS type_7, t0.payment_id AS payment_id_8, t0.captured_by_id AS captured_by_id_9 FROM partial_payments t0 WHERE t0.payment_id = ?
Parameters:
[
  11098
]
17 0.31 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.thumb_filename AS thumb_filename_3, t0.type AS type_4, t0.category AS category_5, t0.folder AS folder_6, t0.clients_id AS clients_id_7, t0.payments_id AS payments_id_8, t0.partial_payments_id AS partial_payments_id_9 FROM media t0 WHERE t0.partial_payments_id = ?
Parameters:
[
  5601
]
18 0.31 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.thumb_filename AS thumb_filename_3, t0.type AS type_4, t0.category AS category_5, t0.folder AS folder_6, t0.clients_id AS clients_id_7, t0.payments_id AS payments_id_8, t0.partial_payments_id AS partial_payments_id_9 FROM media t0 WHERE t0.partial_payments_id = ?
Parameters:
[
  4713
]
19 0.22 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.thumb_filename AS thumb_filename_3, t0.type AS type_4, t0.category AS category_5, t0.folder AS folder_6, t0.clients_id AS clients_id_7, t0.payments_id AS payments_id_8, t0.partial_payments_id AS partial_payments_id_9 FROM media t0 WHERE t0.payments_id = ?
Parameters:
[
  11099
]
20 0.27 ms
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.created_at AS created_at_3, t0.amount AS amount_4, t0.folio AS folio_5, t0.status AS status_6, t0.type AS type_7, t0.payment_id AS payment_id_8, t0.captured_by_id AS captured_by_id_9 FROM partial_payments t0 WHERE t0.payment_id = ?
Parameters:
[
  11099
]
21 0.25 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.thumb_filename AS thumb_filename_3, t0.type AS type_4, t0.category AS category_5, t0.folder AS folder_6, t0.clients_id AS clients_id_7, t0.payments_id AS payments_id_8, t0.partial_payments_id AS partial_payments_id_9 FROM media t0 WHERE t0.partial_payments_id = ?
Parameters:
[
  5600
]
22 0.26 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.thumb_filename AS thumb_filename_3, t0.type AS type_4, t0.category AS category_5, t0.folder AS folder_6, t0.clients_id AS clients_id_7, t0.payments_id AS payments_id_8, t0.partial_payments_id AS partial_payments_id_9 FROM media t0 WHERE t0.payments_id = ?
Parameters:
[
  11100
]
23 0.27 ms
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.created_at AS created_at_3, t0.amount AS amount_4, t0.folio AS folio_5, t0.status AS status_6, t0.type AS type_7, t0.payment_id AS payment_id_8, t0.captured_by_id AS captured_by_id_9 FROM partial_payments t0 WHERE t0.payment_id = ?
Parameters:
[
  11100
]
24 0.24 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.thumb_filename AS thumb_filename_3, t0.type AS type_4, t0.category AS category_5, t0.folder AS folder_6, t0.clients_id AS clients_id_7, t0.payments_id AS payments_id_8, t0.partial_payments_id AS partial_payments_id_9 FROM media t0 WHERE t0.payments_id = ?
Parameters:
[
  11101
]
25 0.23 ms
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.created_at AS created_at_3, t0.amount AS amount_4, t0.folio AS folio_5, t0.status AS status_6, t0.type AS type_7, t0.payment_id AS payment_id_8, t0.captured_by_id AS captured_by_id_9 FROM partial_payments t0 WHERE t0.payment_id = ?
Parameters:
[
  11101
]
26 0.24 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.thumb_filename AS thumb_filename_3, t0.type AS type_4, t0.category AS category_5, t0.folder AS folder_6, t0.clients_id AS clients_id_7, t0.payments_id AS payments_id_8, t0.partial_payments_id AS partial_payments_id_9 FROM media t0 WHERE t0.payments_id = ?
Parameters:
[
  11102
]
27 0.25 ms
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.created_at AS created_at_3, t0.amount AS amount_4, t0.folio AS folio_5, t0.status AS status_6, t0.type AS type_7, t0.payment_id AS payment_id_8, t0.captured_by_id AS captured_by_id_9 FROM partial_payments t0 WHERE t0.payment_id = ?
Parameters:
[
  11102
]
28 0.23 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.thumb_filename AS thumb_filename_3, t0.type AS type_4, t0.category AS category_5, t0.folder AS folder_6, t0.clients_id AS clients_id_7, t0.payments_id AS payments_id_8, t0.partial_payments_id AS partial_payments_id_9 FROM media t0 WHERE t0.payments_id = ?
Parameters:
[
  11103
]
29 0.30 ms
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.created_at AS created_at_3, t0.amount AS amount_4, t0.folio AS folio_5, t0.status AS status_6, t0.type AS type_7, t0.payment_id AS payment_id_8, t0.captured_by_id AS captured_by_id_9 FROM partial_payments t0 WHERE t0.payment_id = ?
Parameters:
[
  11103
]
30 0.30 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.thumb_filename AS thumb_filename_3, t0.type AS type_4, t0.category AS category_5, t0.folder AS folder_6, t0.clients_id AS clients_id_7, t0.payments_id AS payments_id_8, t0.partial_payments_id AS partial_payments_id_9 FROM media t0 WHERE t0.payments_id = ?
Parameters:
[
  11104
]
31 0.23 ms
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.created_at AS created_at_3, t0.amount AS amount_4, t0.folio AS folio_5, t0.status AS status_6, t0.type AS type_7, t0.payment_id AS payment_id_8, t0.captured_by_id AS captured_by_id_9 FROM partial_payments t0 WHERE t0.payment_id = ?
Parameters:
[
  11104
]
32 0.24 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.thumb_filename AS thumb_filename_3, t0.type AS type_4, t0.category AS category_5, t0.folder AS folder_6, t0.clients_id AS clients_id_7, t0.payments_id AS payments_id_8, t0.partial_payments_id AS partial_payments_id_9 FROM media t0 WHERE t0.payments_id = ?
Parameters:
[
  11105
]
33 0.25 ms
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.created_at AS created_at_3, t0.amount AS amount_4, t0.folio AS folio_5, t0.status AS status_6, t0.type AS type_7, t0.payment_id AS payment_id_8, t0.captured_by_id AS captured_by_id_9 FROM partial_payments t0 WHERE t0.payment_id = ?
Parameters:
[
  11105
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Users
  • The field App\Entity\Users#orders is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Orders#createdBy does not contain the required 'inversedBy="orders"' attribute.
  • The field App\Entity\Users#vouchersCreated is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Vouchers#createdBy does not contain the required 'inversedBy="vouchersCreated"' attribute.
  • The field App\Entity\Users#partialPayments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PartialPayments#capturedBy does not contain the required 'inversedBy="partialPayments"' attribute.
  • The field App\Entity\Users#clients is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Clients#createdBy does not contain the required 'inversedBy="clients"' attribute.
App\Entity\Warehouses No errors.
App\Entity\Vouchers No errors.
App\Entity\Orders
  • The mappings App\Entity\Orders#salesCloser and App\Entity\Users#orders are inconsistent with each other.
  • The mappings App\Entity\Orders#speaker and App\Entity\Users#orders are inconsistent with each other.
  • The mappings App\Entity\Orders#coordinator and App\Entity\Users#orders are inconsistent with each other.
  • The mappings App\Entity\Orders#leader and App\Entity\Users#orders are inconsistent with each other.
App\Entity\Payments No errors.
App\Entity\PartialPayments No errors.
App\Entity\Clients No errors.
App\Entity\Vendor No errors.
App\Entity\Routes No errors.
App\Entity\DebtCollectors No errors.
App\Entity\OrderItems No errors.
App\Entity\ClientAddresses No errors.
App\Entity\ClientPhoneNumbers No errors.
App\Entity\Media No errors.