GET https://recette.prestocuisine.fr/api/presto-bi/customers

Query Metrics

5 Database Queries
5 Different statements
90,73 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 3,10 ms
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.isDelivered AS isDelivered_2 FROM tbl_customer_category t0_
Parameters:
[]
2 2,33 ms
SELECT t0_.id AS id_0, t0_.name AS name_1 FROM tbl_customer_typology t0_
Parameters:
[]
3 2,46 ms
SELECT t0_.id AS id_0, t0_.name AS name_1 FROM tbl_helper_pillar t0_
Parameters:
[]
4 3,55 ms
SELECT t0_.id AS id_0, t0_.name AS name_1, t1_.id AS id_2 FROM tbl_helper_sub_pillar t0_ LEFT JOIN tbl_helper_pillar t1_ ON t0_.pillar_id = t1_.id
Parameters:
[]
5 79,29 ms
SELECT t0_.id AS id_0, t0_.isActive AS isActive_1, t0_.reference AS reference_2, t0_.name AS name_3, t1_.id AS id_4, t2_.id AS id_5, t3_.id AS id_6, t4_.id AS id_7 FROM tbl_customer t0_ LEFT JOIN tbl_customer_typology t1_ ON t0_.typology_id = t1_.id LEFT JOIN tbl_customer_category t2_ ON t0_.category_id = t2_.id LEFT JOIN tbl_helper_pillar t3_ ON t0_.pillar_id = t3_.id LEFT JOIN tbl_helper_sub_pillar t4_ ON t0_.subPillar_id = t4_.id
Parameters:
[]

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