Query Metrics
5
Database Queries
5
Different statements
90,73 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
79,29 ms (87,39%) |
1 |
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:
[] |
|
3,55 ms (3,91%) |
1 |
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:
[] |
|
3,10 ms (3,41%) |
1 |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.isDelivered AS isDelivered_2 FROM tbl_customer_category t0_
Parameters:
[] |
|
2,46 ms (2,72%) |
1 |
SELECT t0_.id AS id_0, t0_.name AS name_1 FROM tbl_helper_pillar t0_
Parameters:
[] |
|
2,33 ms (2,57%) |
1 |
SELECT t0_.id AS id_0, t0_.name AS name_1 FROM tbl_customer_typology t0_
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
| Class | Mapping errors |
|---|---|
| App\Entity\Customer\CustomerCategory | No errors. |
| App\Entity\Helper\Typology | No errors. |
| App\Entity\Helper\Pillar | No errors. |
| App\Entity\Helper\SubPillar | No errors. |
| App\Entity\Customer\Customer | No errors. |