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

Query Metrics

6 Database Queries
4 Different statements
2.81 ms Query time
0 Invalid entities
20 Managed entities

Queries

Group similar statements

# Time Info
1 0.65 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.78 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
]
3 0.44 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
]
4 0.29 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
]
5 0.36 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
]
6 0.29 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\ConfigApp 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\History No errors.
App\Entity\Inventory No errors.
App\Entity\InventoryStock No errors.
App\Entity\Sale No errors.
App\Entity\SessionSale No errors.
App\Entity\Cart No errors.
App\Entity\HistoryPurchaseOrder No errors.
App\Entity\HistoryFund No errors.
App\Entity\Category No errors.
App\Entity\ProductStock No errors.
App\Entity\Product No errors.
App\Entity\ConfigApp No errors.