GET https://www.servicioseducativosnaku.com.mx/admin/vouchers/edit/689

Query Metrics

12 Database Queries
6 Different statements
5.35 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.50 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:
[
  28
]
2 0.58 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.is_active AS is_active_3, t0.updated_at AS updated_at_4, t0.created_at AS created_at_5, t0.items AS items_6, t0.status AS status_7, t0.comments AS comments_8, t0.movement_type AS movement_type_9, t0.previous_items AS previous_items_10, t0.applicant_id AS applicant_id_11, t0.warehouse_id AS warehouse_id_12, t0.created_by_id AS created_by_id_13 FROM vouchers t0 WHERE t0.id = ?
Parameters:
[
  689
]
3 0.54 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.is_active AS is_active_3, t0.updated_at AS updated_at_4, t0.created_at AS created_at_5, t0.status AS status_6, t0.quantity_returned AS quantity_returned_7, t0.available_quantity AS available_quantity_8, t0.product_id AS product_id_9, t0.voucher_id AS voucher_id_10 FROM voucher_items t0 WHERE t0.voucher_id = ?
Parameters:
[
  689
]
4 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.compare_at_price AS compare_at_price_5, t0.sku AS sku_6, t0.stock AS stock_7, t0.is_active AS is_active_8, t0.updated_at AS updated_at_9, t0.created_at AS created_at_10, t0.image AS image_11, t0.warehouse_id AS warehouse_id_12, t0.category_id AS category_id_13, t0.vendor_id AS vendor_id_14 FROM products t0 WHERE t0.id = ?
Parameters:
[
  95
]
5 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.compare_at_price AS compare_at_price_5, t0.sku AS sku_6, t0.stock AS stock_7, t0.is_active AS is_active_8, t0.updated_at AS updated_at_9, t0.created_at AS created_at_10, t0.image AS image_11, t0.warehouse_id AS warehouse_id_12, t0.category_id AS category_id_13, t0.vendor_id AS vendor_id_14 FROM products t0 WHERE t0.id = ?
Parameters:
[
  98
]
6 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.compare_at_price AS compare_at_price_5, t0.sku AS sku_6, t0.stock AS stock_7, t0.is_active AS is_active_8, t0.updated_at AS updated_at_9, t0.created_at AS created_at_10, t0.image AS image_11, t0.warehouse_id AS warehouse_id_12, t0.category_id AS category_id_13, t0.vendor_id AS vendor_id_14 FROM products t0 WHERE t0.id = ?
Parameters:
[
  116
]
7 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.compare_at_price AS compare_at_price_5, t0.sku AS sku_6, t0.stock AS stock_7, t0.is_active AS is_active_8, t0.updated_at AS updated_at_9, t0.created_at AS created_at_10, t0.image AS image_11, t0.warehouse_id AS warehouse_id_12, t0.category_id AS category_id_13, t0.vendor_id AS vendor_id_14 FROM products t0 WHERE t0.id = ?
Parameters:
[
  135
]
8 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.compare_at_price AS compare_at_price_5, t0.sku AS sku_6, t0.stock AS stock_7, t0.is_active AS is_active_8, t0.updated_at AS updated_at_9, t0.created_at AS created_at_10, t0.image AS image_11, t0.warehouse_id AS warehouse_id_12, t0.category_id AS category_id_13, t0.vendor_id AS vendor_id_14 FROM products t0 WHERE t0.id = ?
Parameters:
[
  107
]
9 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.compare_at_price AS compare_at_price_5, t0.sku AS sku_6, t0.stock AS stock_7, t0.is_active AS is_active_8, t0.updated_at AS updated_at_9, t0.created_at AS created_at_10, t0.image AS image_11, t0.warehouse_id AS warehouse_id_12, t0.category_id AS category_id_13, t0.vendor_id AS vendor_id_14 FROM products t0 WHERE t0.id = ?
Parameters:
[
  104
]
10 0.74 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.price AS price_3, p0_.compare_at_price AS compare_at_price_4, p0_.sku AS sku_5, p0_.stock AS stock_6, p0_.is_active AS is_active_7, p0_.updated_at AS updated_at_8, p0_.created_at AS created_at_9, p0_.image AS image_10, p0_.warehouse_id AS warehouse_id_11, p0_.category_id AS category_id_12, p0_.vendor_id AS vendor_id_13 FROM products p0_
Parameters:
[]
11 0.54 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.is_active AS is_active_4, t0.updated_at AS updated_at_5, t0.created_at AS created_at_6 FROM warehouses t0 WHERE t0.id = ?
Parameters:
[
  6
]
12 0.51 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:
[
  18
]

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\VoucherItems No errors.
App\Entity\Products No errors.
App\Entity\OrderItems No errors.
App\Entity\ProductCategories No errors.
App\Entity\Vendor No errors.
App\Entity\ProductImages No errors.