Query Metrics
21
Database Queries
2
Different statements
44.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
35.88 ms (80.54%) |
20 |
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.weight_max AS weight_max_5, t0.weight_min AS weight_min_6, t0.price_max AS price_max_7, t0.price_min AS price_min_8, t0.recycle_price AS recycle_price_9, t0.code AS code_10, t0.refundable AS refundable_11, t0.color AS color_12, t0.name AS name_13, t0.enabled AS enabled_14, t0.weight AS weight_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17, t0.deleted_by AS deleted_by_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.picture_id AS picture_id_21, t0.tree_root AS tree_root_22, t0.parent_id AS parent_id_23 FROM waste_categories t0 WHERE t0.parent_id = ? ORDER BY t0.lft ASC
Parameters:
[
1
]
|
|
8.67 ms (19.46%) |
1 |
SELECT w0_.id AS id_0, w0_.lft AS lft_1, w0_.lvl AS lvl_2, w0_.rgt AS rgt_3, w0_.weight_max AS weight_max_4, w0_.weight_min AS weight_min_5, w0_.price_max AS price_max_6, w0_.price_min AS price_min_7, w0_.recycle_price AS recycle_price_8, w0_.code AS code_9, w0_.refundable AS refundable_10, w0_.color AS color_11, w0_.name AS name_12, w0_.enabled AS enabled_13, w0_.weight AS weight_14, w0_.created_by AS created_by_15, w0_.updated_by AS updated_by_16, w0_.deleted_by AS deleted_by_17, w0_.created_at AS created_at_18, w0_.updated_at AS updated_at_19, w0_.picture_id AS picture_id_20, w0_.tree_root AS tree_root_21, w0_.parent_id AS parent_id_22 FROM waste_categories w0_ ORDER BY w0_.id ASC
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 |
|---|---|
| Revo\Bundle\CoreBundle\Entity\WasteCategory | No errors. |
| Revo\Bundle\CoreBundle\Entity\Parameter | No errors. |
| Revo\Bundle\CoreBundle\Entity\Media | No errors. |
| Revo\Bundle\CoreBundle\Entity\WasteCategoryImage | No errors. |