GET http://dev-connect-pos.binn.pro/product/show/358

Query Metrics

10 Database Queries
8 Different statements
4.04 ms Query time
0 Invalid entities
21 Managed entities

Queries

Group similar statements

# Time Info
1 0.60 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.image AS image_7, t0.adresse AS adresse_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.archive_status AS archive_status_11, t0.is_email_received AS is_email_received_12, t0.is_sms_received AS is_sms_received_13, t0.point_of_sale_id AS point_of_sale_id_14 FROM user t0 WHERE t0.id = ?
Parameters:
[
  89
]
2 0.45 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.quantity AS quantity_3, t0.purchase_price AS purchase_price_4, t0.bulk_price AS bulk_price_5, t0.retail_price AS retail_price_6, t0.manufacturing_date AS manufacturing_date_7, t0.expiration_date AS expiration_date_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.archive_status AS archive_status_11, t0.image AS image_12, t0.invoice_purchase AS invoice_purchase_13, t0.purchase_date AS purchase_date_14, t0.certificate_origin AS certificate_origin_15, t0.approval_certificate AS approval_certificate_16, t0.status_en_stock AS status_en_stock_17, t0.is_raw_material AS is_raw_material_18, t0.status AS status_19, t0.description AS description_20, t0.unit_of_measurement AS unit_of_measurement_21, t0.point_of_sale_id AS point_of_sale_id_22, t0.category_id AS category_id_23, t0.supplier_id AS supplier_id_24 FROM product t0 WHERE t0.id = ?
Parameters:
[
  "358"
]
3 0.61 ms
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.product_id AS product_id_3, t0.product_stock_id AS product_stock_id_4 FROM sale_product_stock t0 WHERE t0.product_id = ?
Parameters:
[
  358
]
4 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.archive_status AS archive_status_5, t0.type AS type_6, t0.point_of_sale_id AS point_of_sale_id_7, t0.category_id AS category_id_8 FROM category t0 WHERE t0.id = ?
Parameters:
[
  150
]
5 0.44 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.created_at AS created_at_2, c0_.updated_at AS updated_at_3, c0_.archive_status AS archive_status_4, c0_.type AS type_5, c0_.point_of_sale_id AS point_of_sale_id_6, c0_.category_id AS category_id_7 FROM category c0_ WHERE (c0_.archive_status = 0 OR c0_.archive_status IS NULL) AND c0_.point_of_sale_id = ? ORDER BY c0_.id DESC
Parameters:
[
  55
]
6 0.40 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.adresse AS adresse_2, s0_.phone_number AS phone_number_3, s0_.email AS email_4, s0_.site_web AS site_web_5, s0_.payment_terms AS payment_terms_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.status_supplier AS status_supplier_9, s0_.logo AS logo_10, s0_.country AS country_11, s0_.city AS city_12, s0_.archive_status AS archive_status_13, s0_.point_of_sale_id AS point_of_sale_id_14, s0_.field_of_activity_id AS field_of_activity_id_15 FROM supplier s0_ WHERE (s0_.archive_status = 0 OR s0_.archive_status IS NULL) AND s0_.point_of_sale_id = ? ORDER BY s0_.id DESC
Parameters:
[
  55
]
7 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.phone_number AS phone_number_4, t0.address AS address_5, t0.rccm AS rccm_6, t0.country AS country_7, t0.city AS city_8, t0.email AS email_9, t0.point_of_sale AS point_of_sale_10, t0.business_user AS business_user_11, t0.receipt_format AS receipt_format_12 FROM config_app t0 WHERE t0.point_of_sale = ? LIMIT 1
Parameters:
[
  55
]
8 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.phone_number AS phone_number_4, t0.address AS address_5, t0.rccm AS rccm_6, t0.country AS country_7, t0.city AS city_8, t0.email AS email_9, t0.point_of_sale AS point_of_sale_10, t0.business_user AS business_user_11, t0.receipt_format AS receipt_format_12 FROM config_app t0 WHERE t0.point_of_sale = ? LIMIT 1
Parameters:
[
  55
]
9 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.phone_number AS phone_number_4, t0.address AS address_5, t0.rccm AS rccm_6, t0.country AS country_7, t0.city AS city_8, t0.email AS email_9, t0.point_of_sale AS point_of_sale_10, t0.business_user AS business_user_11, t0.receipt_format AS receipt_format_12 FROM config_app t0 WHERE t0.point_of_sale = ? LIMIT 1
Parameters:
[
  55
]
10 0.27 ms
SELECT t0.id AS id_1, t0.start AS start_2, t0.end AS end_3, t0.status AS status_4, t0.status_for_manager AS status_for_manager_5, t0.point_of_sale_id AS point_of_sale_id_6, t0.user_id AS user_id_7 FROM session_sale t0 WHERE t0.user_id = ?
Parameters:
[
  89
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Category 18
App\Entity\User 1
App\Entity\Product 1
App\Entity\ConfigApp 1