GET https://www.deltamics-connect.fr/client/5407

Query Metrics

6 Database Queries
6 Different statements
293.01 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 267.74 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.firstname AS firstname_6, t0.sales_person_code AS sales_person_code_7, t0.function AS function_8 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  2
]
2 14.95 ms
SELECT t0.id AS id_1, t0.no AS no_2, t0.name AS name_3, t0.address AS address_4, t0.city AS city_5, t0.contact AS contact_6, t0.phone AS phone_7, t0.salesperson_code AS salesperson_code_8, t0.blocked AS blocked_9, t0.post_code AS post_code_10, t0.address2 AS address2_11, t0.sales_lcy AS sales_lcy_12, t0.latitude AS latitude_13, t0.longitude AS longitude_14, t0.active AS active_15, t0.show_on_web AS show_on_web_16 FROM client t0 WHERE t0.no = ? LIMIT 1
Parameters:
[
  "5407"
]
3 0.51 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.met_people AS met_people_3, t0.stocked_items AS stocked_items_4, t0.comment AS comment_5, t0.week_number AS week_number_6, t0.token AS token_7, t0.state AS state_8, t0.year AS year_9, t0.client_id AS client_id_10 FROM visit t0 WHERE t0.client_id = ? ORDER BY t0.id DESC
Parameters:
[
  563
]
4 7.18 ms
SELECT t0.id AS id_1, t0.no AS no_2, t0.name AS name_3, t0.address AS address_4, t0.city AS city_5, t0.contact AS contact_6, t0.phone AS phone_7, t0.salesperson_code AS salesperson_code_8, t0.blocked AS blocked_9, t0.post_code AS post_code_10, t0.address2 AS address2_11, t0.sales_lcy AS sales_lcy_12, t0.latitude AS latitude_13, t0.longitude AS longitude_14, t0.active AS active_15, t0.show_on_web AS show_on_web_16 FROM client t0 WHERE t0.no = ?
Parameters:
[
  "5407"
]
5 1.50 ms
SELECT t0.id AS id_1, t0.no AS no_2, t0.description AS description_3, t0.unit_price AS unit_price_4, t0.gen_prod_posting_group AS gen_prod_posting_group_5, t0.item_category_code AS item_category_code_6, t0.brand AS brand_7, t0.inventory_field AS inventory_field_8, t0.description2 AS description2_9, t0.qty_on_sales_order AS qty_on_sales_order_10, t0.qty_on_purch_order AS qty_on_purch_order_11, t0.sales_qty AS sales_qty_12, t0.purchases_qty AS purchases_qty_13, t0.model AS model_14, t0.consigned AS consigned_15 FROM item t0 WHERE t0.no IN (NULL)
Parameters:
[]
6 1.13 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.firstname AS firstname_6, t0.sales_person_code AS sales_person_code_7, t0.function AS function_8 FROM `user` t0 WHERE t0.sales_person_code = ? LIMIT 1
Parameters:
[
  "15"
]

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\User No errors.
App\Entity\Client No errors.
App\Entity\Visit No errors.
App\Entity\Activity No errors.
App\Entity\Access No errors.
App\Entity\Item No errors.