GET https://revox.ressourcesetvous.org/api/waste_categories

Query Metrics

28 Database Queries
2 Different statements
16.35 ms Query time
0 Invalid entities
27 Managed entities

Queries

Group similar statements

#▲ Time Info
1 2.83 ms
SELECT w0_.id AS id_0, w0_.lft AS lft_1, w0_.lvl AS lvl_2, w0_.rgt AS rgt_3, w0_.position AS position_4, w0_.weight_max AS weight_max_5, w0_.weight_min AS weight_min_6, w0_.price_max AS price_max_7, w0_.price_min AS price_min_8, w0_.recycle_price AS recycle_price_9, w0_.code AS code_10, w0_.refundable AS refundable_11, w0_.color AS color_12, w0_.name AS name_13, w0_.enabled AS enabled_14, w0_.weight AS weight_15, w0_.created_by AS created_by_16, w0_.updated_by AS updated_by_17, w0_.deleted_by AS deleted_by_18, w0_.created_at AS created_at_19, w0_.updated_at AS updated_at_20, w0_.picture_id AS picture_id_21, w0_.tree_root AS tree_root_22, w0_.parent_id AS parent_id_23 FROM waste_categories w0_ ORDER BY w0_.id ASC
Parameters:
[]
2 0.80 ms
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.position AS position_5, t0.weight_max AS weight_max_6, t0.weight_min AS weight_min_7, t0.price_max AS price_max_8, t0.price_min AS price_min_9, t0.recycle_price AS recycle_price_10, t0.code AS code_11, t0.refundable AS refundable_12, t0.color AS color_13, t0.name AS name_14, t0.enabled AS enabled_15, t0.weight AS weight_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.picture_id AS picture_id_22, t0.tree_root AS tree_root_23, t0.parent_id AS parent_id_24 FROM waste_categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
3 0.46 ms
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.position AS position_5, t0.weight_max AS weight_max_6, t0.weight_min AS weight_min_7, t0.price_max AS price_max_8, t0.price_min AS price_min_9, t0.recycle_price AS recycle_price_10, t0.code AS code_11, t0.refundable AS refundable_12, t0.color AS color_13, t0.name AS name_14, t0.enabled AS enabled_15, t0.weight AS weight_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.picture_id AS picture_id_22, t0.tree_root AS tree_root_23, t0.parent_id AS parent_id_24 FROM waste_categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  11
]
4 0.48 ms
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.position AS position_5, t0.weight_max AS weight_max_6, t0.weight_min AS weight_min_7, t0.price_max AS price_max_8, t0.price_min AS price_min_9, t0.recycle_price AS recycle_price_10, t0.code AS code_11, t0.refundable AS refundable_12, t0.color AS color_13, t0.name AS name_14, t0.enabled AS enabled_15, t0.weight AS weight_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.picture_id AS picture_id_22, t0.tree_root AS tree_root_23, t0.parent_id AS parent_id_24 FROM waste_categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  15
]
5 0.49 ms
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.position AS position_5, t0.weight_max AS weight_max_6, t0.weight_min AS weight_min_7, t0.price_max AS price_max_8, t0.price_min AS price_min_9, t0.recycle_price AS recycle_price_10, t0.code AS code_11, t0.refundable AS refundable_12, t0.color AS color_13, t0.name AS name_14, t0.enabled AS enabled_15, t0.weight AS weight_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.picture_id AS picture_id_22, t0.tree_root AS tree_root_23, t0.parent_id AS parent_id_24 FROM waste_categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  19
]
6 0.52 ms
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.position AS position_5, t0.weight_max AS weight_max_6, t0.weight_min AS weight_min_7, t0.price_max AS price_max_8, t0.price_min AS price_min_9, t0.recycle_price AS recycle_price_10, t0.code AS code_11, t0.refundable AS refundable_12, t0.color AS color_13, t0.name AS name_14, t0.enabled AS enabled_15, t0.weight AS weight_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.picture_id AS picture_id_22, t0.tree_root AS tree_root_23, t0.parent_id AS parent_id_24 FROM waste_categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  25
]
7 0.48 ms
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.position AS position_5, t0.weight_max AS weight_max_6, t0.weight_min AS weight_min_7, t0.price_max AS price_max_8, t0.price_min AS price_min_9, t0.recycle_price AS recycle_price_10, t0.code AS code_11, t0.refundable AS refundable_12, t0.color AS color_13, t0.name AS name_14, t0.enabled AS enabled_15, t0.weight AS weight_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.picture_id AS picture_id_22, t0.tree_root AS tree_root_23, t0.parent_id AS parent_id_24 FROM waste_categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  30
]
8 0.46 ms
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.position AS position_5, t0.weight_max AS weight_max_6, t0.weight_min AS weight_min_7, t0.price_max AS price_max_8, t0.price_min AS price_min_9, t0.recycle_price AS recycle_price_10, t0.code AS code_11, t0.refundable AS refundable_12, t0.color AS color_13, t0.name AS name_14, t0.enabled AS enabled_15, t0.weight AS weight_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.picture_id AS picture_id_22, t0.tree_root AS tree_root_23, t0.parent_id AS parent_id_24 FROM waste_categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  33
]
9 0.44 ms
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.position AS position_5, t0.weight_max AS weight_max_6, t0.weight_min AS weight_min_7, t0.price_max AS price_max_8, t0.price_min AS price_min_9, t0.recycle_price AS recycle_price_10, t0.code AS code_11, t0.refundable AS refundable_12, t0.color AS color_13, t0.name AS name_14, t0.enabled AS enabled_15, t0.weight AS weight_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.picture_id AS picture_id_22, t0.tree_root AS tree_root_23, t0.parent_id AS parent_id_24 FROM waste_categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  34
]
10 0.46 ms
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.position AS position_5, t0.weight_max AS weight_max_6, t0.weight_min AS weight_min_7, t0.price_max AS price_max_8, t0.price_min AS price_min_9, t0.recycle_price AS recycle_price_10, t0.code AS code_11, t0.refundable AS refundable_12, t0.color AS color_13, t0.name AS name_14, t0.enabled AS enabled_15, t0.weight AS weight_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.picture_id AS picture_id_22, t0.tree_root AS tree_root_23, t0.parent_id AS parent_id_24 FROM waste_categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  35
]
11 0.44 ms
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.position AS position_5, t0.weight_max AS weight_max_6, t0.weight_min AS weight_min_7, t0.price_max AS price_max_8, t0.price_min AS price_min_9, t0.recycle_price AS recycle_price_10, t0.code AS code_11, t0.refundable AS refundable_12, t0.color AS color_13, t0.name AS name_14, t0.enabled AS enabled_15, t0.weight AS weight_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.picture_id AS picture_id_22, t0.tree_root AS tree_root_23, t0.parent_id AS parent_id_24 FROM waste_categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  36
]
12 0.49 ms
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.position AS position_5, t0.weight_max AS weight_max_6, t0.weight_min AS weight_min_7, t0.price_max AS price_max_8, t0.price_min AS price_min_9, t0.recycle_price AS recycle_price_10, t0.code AS code_11, t0.refundable AS refundable_12, t0.color AS color_13, t0.name AS name_14, t0.enabled AS enabled_15, t0.weight AS weight_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.picture_id AS picture_id_22, t0.tree_root AS tree_root_23, t0.parent_id AS parent_id_24 FROM waste_categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  41
]
13 0.48 ms
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.position AS position_5, t0.weight_max AS weight_max_6, t0.weight_min AS weight_min_7, t0.price_max AS price_max_8, t0.price_min AS price_min_9, t0.recycle_price AS recycle_price_10, t0.code AS code_11, t0.refundable AS refundable_12, t0.color AS color_13, t0.name AS name_14, t0.enabled AS enabled_15, t0.weight AS weight_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.picture_id AS picture_id_22, t0.tree_root AS tree_root_23, t0.parent_id AS parent_id_24 FROM waste_categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  49
]
14 0.51 ms
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.position AS position_5, t0.weight_max AS weight_max_6, t0.weight_min AS weight_min_7, t0.price_max AS price_max_8, t0.price_min AS price_min_9, t0.recycle_price AS recycle_price_10, t0.code AS code_11, t0.refundable AS refundable_12, t0.color AS color_13, t0.name AS name_14, t0.enabled AS enabled_15, t0.weight AS weight_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.picture_id AS picture_id_22, t0.tree_root AS tree_root_23, t0.parent_id AS parent_id_24 FROM waste_categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  56
]
15 0.48 ms
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.position AS position_5, t0.weight_max AS weight_max_6, t0.weight_min AS weight_min_7, t0.price_max AS price_max_8, t0.price_min AS price_min_9, t0.recycle_price AS recycle_price_10, t0.code AS code_11, t0.refundable AS refundable_12, t0.color AS color_13, t0.name AS name_14, t0.enabled AS enabled_15, t0.weight AS weight_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.picture_id AS picture_id_22, t0.tree_root AS tree_root_23, t0.parent_id AS parent_id_24 FROM waste_categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  57
]
16 0.45 ms
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.position AS position_5, t0.weight_max AS weight_max_6, t0.weight_min AS weight_min_7, t0.price_max AS price_max_8, t0.price_min AS price_min_9, t0.recycle_price AS recycle_price_10, t0.code AS code_11, t0.refundable AS refundable_12, t0.color AS color_13, t0.name AS name_14, t0.enabled AS enabled_15, t0.weight AS weight_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.picture_id AS picture_id_22, t0.tree_root AS tree_root_23, t0.parent_id AS parent_id_24 FROM waste_categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  58
]
17 0.47 ms
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.position AS position_5, t0.weight_max AS weight_max_6, t0.weight_min AS weight_min_7, t0.price_max AS price_max_8, t0.price_min AS price_min_9, t0.recycle_price AS recycle_price_10, t0.code AS code_11, t0.refundable AS refundable_12, t0.color AS color_13, t0.name AS name_14, t0.enabled AS enabled_15, t0.weight AS weight_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.picture_id AS picture_id_22, t0.tree_root AS tree_root_23, t0.parent_id AS parent_id_24 FROM waste_categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  61
]
18 0.44 ms
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.position AS position_5, t0.weight_max AS weight_max_6, t0.weight_min AS weight_min_7, t0.price_max AS price_max_8, t0.price_min AS price_min_9, t0.recycle_price AS recycle_price_10, t0.code AS code_11, t0.refundable AS refundable_12, t0.color AS color_13, t0.name AS name_14, t0.enabled AS enabled_15, t0.weight AS weight_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.picture_id AS picture_id_22, t0.tree_root AS tree_root_23, t0.parent_id AS parent_id_24 FROM waste_categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  62
]
19 0.48 ms
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.position AS position_5, t0.weight_max AS weight_max_6, t0.weight_min AS weight_min_7, t0.price_max AS price_max_8, t0.price_min AS price_min_9, t0.recycle_price AS recycle_price_10, t0.code AS code_11, t0.refundable AS refundable_12, t0.color AS color_13, t0.name AS name_14, t0.enabled AS enabled_15, t0.weight AS weight_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.picture_id AS picture_id_22, t0.tree_root AS tree_root_23, t0.parent_id AS parent_id_24 FROM waste_categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  63
]
20 0.47 ms
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.position AS position_5, t0.weight_max AS weight_max_6, t0.weight_min AS weight_min_7, t0.price_max AS price_max_8, t0.price_min AS price_min_9, t0.recycle_price AS recycle_price_10, t0.code AS code_11, t0.refundable AS refundable_12, t0.color AS color_13, t0.name AS name_14, t0.enabled AS enabled_15, t0.weight AS weight_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.picture_id AS picture_id_22, t0.tree_root AS tree_root_23, t0.parent_id AS parent_id_24 FROM waste_categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  66
]
21 0.47 ms
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.position AS position_5, t0.weight_max AS weight_max_6, t0.weight_min AS weight_min_7, t0.price_max AS price_max_8, t0.price_min AS price_min_9, t0.recycle_price AS recycle_price_10, t0.code AS code_11, t0.refundable AS refundable_12, t0.color AS color_13, t0.name AS name_14, t0.enabled AS enabled_15, t0.weight AS weight_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.picture_id AS picture_id_22, t0.tree_root AS tree_root_23, t0.parent_id AS parent_id_24 FROM waste_categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  67
]
22 0.52 ms
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.position AS position_5, t0.weight_max AS weight_max_6, t0.weight_min AS weight_min_7, t0.price_max AS price_max_8, t0.price_min AS price_min_9, t0.recycle_price AS recycle_price_10, t0.code AS code_11, t0.refundable AS refundable_12, t0.color AS color_13, t0.name AS name_14, t0.enabled AS enabled_15, t0.weight AS weight_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.picture_id AS picture_id_22, t0.tree_root AS tree_root_23, t0.parent_id AS parent_id_24 FROM waste_categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  68
]
23 0.53 ms
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.position AS position_5, t0.weight_max AS weight_max_6, t0.weight_min AS weight_min_7, t0.price_max AS price_max_8, t0.price_min AS price_min_9, t0.recycle_price AS recycle_price_10, t0.code AS code_11, t0.refundable AS refundable_12, t0.color AS color_13, t0.name AS name_14, t0.enabled AS enabled_15, t0.weight AS weight_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.picture_id AS picture_id_22, t0.tree_root AS tree_root_23, t0.parent_id AS parent_id_24 FROM waste_categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  69
]
24 0.53 ms
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.position AS position_5, t0.weight_max AS weight_max_6, t0.weight_min AS weight_min_7, t0.price_max AS price_max_8, t0.price_min AS price_min_9, t0.recycle_price AS recycle_price_10, t0.code AS code_11, t0.refundable AS refundable_12, t0.color AS color_13, t0.name AS name_14, t0.enabled AS enabled_15, t0.weight AS weight_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.picture_id AS picture_id_22, t0.tree_root AS tree_root_23, t0.parent_id AS parent_id_24 FROM waste_categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  70
]
25 0.58 ms
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.position AS position_5, t0.weight_max AS weight_max_6, t0.weight_min AS weight_min_7, t0.price_max AS price_max_8, t0.price_min AS price_min_9, t0.recycle_price AS recycle_price_10, t0.code AS code_11, t0.refundable AS refundable_12, t0.color AS color_13, t0.name AS name_14, t0.enabled AS enabled_15, t0.weight AS weight_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.picture_id AS picture_id_22, t0.tree_root AS tree_root_23, t0.parent_id AS parent_id_24 FROM waste_categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  71
]
26 0.53 ms
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.position AS position_5, t0.weight_max AS weight_max_6, t0.weight_min AS weight_min_7, t0.price_max AS price_max_8, t0.price_min AS price_min_9, t0.recycle_price AS recycle_price_10, t0.code AS code_11, t0.refundable AS refundable_12, t0.color AS color_13, t0.name AS name_14, t0.enabled AS enabled_15, t0.weight AS weight_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.picture_id AS picture_id_22, t0.tree_root AS tree_root_23, t0.parent_id AS parent_id_24 FROM waste_categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  72
]
27 0.53 ms
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.position AS position_5, t0.weight_max AS weight_max_6, t0.weight_min AS weight_min_7, t0.price_max AS price_max_8, t0.price_min AS price_min_9, t0.recycle_price AS recycle_price_10, t0.code AS code_11, t0.refundable AS refundable_12, t0.color AS color_13, t0.name AS name_14, t0.enabled AS enabled_15, t0.weight AS weight_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.picture_id AS picture_id_22, t0.tree_root AS tree_root_23, t0.parent_id AS parent_id_24 FROM waste_categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  73
]
28 0.56 ms
SELECT t0.id AS id_1, t0.lft AS lft_2, t0.lvl AS lvl_3, t0.rgt AS rgt_4, t0.position AS position_5, t0.weight_max AS weight_max_6, t0.weight_min AS weight_min_7, t0.price_max AS price_max_8, t0.price_min AS price_min_9, t0.recycle_price AS recycle_price_10, t0.code AS code_11, t0.refundable AS refundable_12, t0.color AS color_13, t0.name AS name_14, t0.enabled AS enabled_15, t0.weight AS weight_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.picture_id AS picture_id_22, t0.tree_root AS tree_root_23, t0.parent_id AS parent_id_24 FROM waste_categories t0 WHERE t0.parent_id = ? ORDER BY t0.position ASC
Parameters:
[
  74
]

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
Revo\Bundle\CoreBundle\Entity\WasteCategory 27