Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.priority AS priority_3,
  t0.image AS image_4,
  t0.parent_id AS parent_id_5,
  t6.id AS id_7,
  t6.label AS label_8,
  t6.priority AS priority_9,
  t6.image AS image_10,
  t6.parent_id AS parent_id_11
FROM
  product_category t0
  LEFT JOIN product_category t6 ON t0.parent_id = t6.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.priority AS priority_3, t0.image AS image_4, t0.parent_id AS parent_id_5, t6.id AS id_7, t6.label AS label_8, t6.priority AS priority_9, t6.image AS image_10, t6.parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0.parent_id = t6.id WHERE t0.id = '53';

SELECT
  t0.id AS id_1,
  t0.class AS class_2,
  t0.name AS name_3,
  t0.item_number AS item_number_4,
  t0.size AS size_5,
  t0.shape AS shape_6,
  t0.quantity AS quantity_7,
  t0.weight AS weight_8,
  t0.is_viewable AS is_viewable_9,
  t0.notes AS notes_10,
  t0.image AS image_11,
  t0.product_category_id AS product_category_id_12,
  t0.material_id AS material_id_13
FROM
  product t0
WHERE
  t0.product_category_id = ?

SELECT t0.id AS id_1, t0.class AS class_2, t0.name AS name_3, t0.item_number AS item_number_4, t0.size AS size_5, t0.shape AS shape_6, t0.quantity AS quantity_7, t0.weight AS weight_8, t0.is_viewable AS is_viewable_9, t0.notes AS notes_10, t0.image AS image_11, t0.product_category_id AS product_category_id_12, t0.material_id AS material_id_13 FROM product t0 WHERE t0.product_category_id = 53;

SELECT
  material_id
FROM
  product
WHERE
  product_category_id = ?

SELECT material_id FROM product WHERE product_category_id = ?;

SELECT
  t0.id AS id_1,
  t0.material AS material_2
FROM
  material t0
WHERE
  t0.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0.material AS material_2 FROM material t0 WHERE t0.id IN (8, 8, 8, 8, 18, 18, 18, 18, 20, 8, 8, 20, 20, 20, 8, 8, 20, 20, 8, 8);

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.priority AS priority_3,
  t0.image AS image_4,
  t0.parent_id AS parent_id_5,
  t6.id AS id_7,
  t6.label AS label_8,
  t6.priority AS priority_9,
  t6.image AS image_10,
  t6.parent_id AS parent_id_11
FROM
  product_category t0
  LEFT JOIN product_category t6 ON t0.parent_id = t6.id
WHERE
  t0.parent_id IS NULL
ORDER BY
  t0.priority ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.priority AS priority_3, t0.image AS image_4, t0.parent_id AS parent_id_5, t6.id AS id_7, t6.label AS label_8, t6.priority AS priority_9, t6.image AS image_10, t6.parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0.parent_id = t6.id WHERE t0.parent_id IS NULL ORDER BY t0.priority ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.priority AS priority_3,
  t0.image AS image_4,
  t0.parent_id AS parent_id_5,
  t6.id AS id_7,
  t6.label AS label_8,
  t6.priority AS priority_9,
  t6.image AS image_10,
  t6.parent_id AS parent_id_11
FROM
  product_category t0
  LEFT JOIN product_category t6 ON t0.parent_id = t6.id
WHERE
  t0.parent_id = ?
ORDER BY
  t0.priority ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.priority AS priority_3, t0.image AS image_4, t0.parent_id AS parent_id_5, t6.id AS id_7, t6.label AS label_8, t6.priority AS priority_9, t6.image AS image_10, t6.parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0.parent_id = t6.id WHERE t0.parent_id = 1 ORDER BY t0.priority ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.priority AS priority_3,
  t0.image AS image_4,
  t0.parent_id AS parent_id_5,
  t6.id AS id_7,
  t6.label AS label_8,
  t6.priority AS priority_9,
  t6.image AS image_10,
  t6.parent_id AS parent_id_11
FROM
  product_category t0
  LEFT JOIN product_category t6 ON t0.parent_id = t6.id
WHERE
  t0.parent_id = ?
ORDER BY
  t0.priority ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.priority AS priority_3, t0.image AS image_4, t0.parent_id AS parent_id_5, t6.id AS id_7, t6.label AS label_8, t6.priority AS priority_9, t6.image AS image_10, t6.parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0.parent_id = t6.id WHERE t0.parent_id = 2 ORDER BY t0.priority ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.priority AS priority_3,
  t0.image AS image_4,
  t0.parent_id AS parent_id_5,
  t6.id AS id_7,
  t6.label AS label_8,
  t6.priority AS priority_9,
  t6.image AS image_10,
  t6.parent_id AS parent_id_11
FROM
  product_category t0
  LEFT JOIN product_category t6 ON t0.parent_id = t6.id
WHERE
  t0.parent_id = ?
ORDER BY
  t0.priority ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.priority AS priority_3, t0.image AS image_4, t0.parent_id AS parent_id_5, t6.id AS id_7, t6.label AS label_8, t6.priority AS priority_9, t6.image AS image_10, t6.parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0.parent_id = t6.id WHERE t0.parent_id = 3 ORDER BY t0.priority ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.priority AS priority_3,
  t0.image AS image_4,
  t0.parent_id AS parent_id_5,
  t6.id AS id_7,
  t6.label AS label_8,
  t6.priority AS priority_9,
  t6.image AS image_10,
  t6.parent_id AS parent_id_11
FROM
  product_category t0
  LEFT JOIN product_category t6 ON t0.parent_id = t6.id
WHERE
  t0.parent_id = ?
ORDER BY
  t0.priority ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.priority AS priority_3, t0.image AS image_4, t0.parent_id AS parent_id_5, t6.id AS id_7, t6.label AS label_8, t6.priority AS priority_9, t6.image AS image_10, t6.parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0.parent_id = t6.id WHERE t0.parent_id = 4 ORDER BY t0.priority ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.priority AS priority_3,
  t0.image AS image_4,
  t0.parent_id AS parent_id_5,
  t6.id AS id_7,
  t6.label AS label_8,
  t6.priority AS priority_9,
  t6.image AS image_10,
  t6.parent_id AS parent_id_11
FROM
  product_category t0
  LEFT JOIN product_category t6 ON t0.parent_id = t6.id
WHERE
  t0.parent_id = ?
ORDER BY
  t0.priority ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.priority AS priority_3, t0.image AS image_4, t0.parent_id AS parent_id_5, t6.id AS id_7, t6.label AS label_8, t6.priority AS priority_9, t6.image AS image_10, t6.parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0.parent_id = t6.id WHERE t0.parent_id = 5 ORDER BY t0.priority ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.priority AS priority_3,
  t0.image AS image_4,
  t0.parent_id AS parent_id_5,
  t6.id AS id_7,
  t6.label AS label_8,
  t6.priority AS priority_9,
  t6.image AS image_10,
  t6.parent_id AS parent_id_11
FROM
  product_category t0
  LEFT JOIN product_category t6 ON t0.parent_id = t6.id
WHERE
  t0.parent_id = ?
ORDER BY
  t0.priority ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.priority AS priority_3, t0.image AS image_4, t0.parent_id AS parent_id_5, t6.id AS id_7, t6.label AS label_8, t6.priority AS priority_9, t6.image AS image_10, t6.parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0.parent_id = t6.id WHERE t0.parent_id = 6 ORDER BY t0.priority ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.priority AS priority_3,
  t0.image AS image_4,
  t0.parent_id AS parent_id_5,
  t6.id AS id_7,
  t6.label AS label_8,
  t6.priority AS priority_9,
  t6.image AS image_10,
  t6.parent_id AS parent_id_11
FROM
  product_category t0
  LEFT JOIN product_category t6 ON t0.parent_id = t6.id
WHERE
  t0.parent_id = ?
ORDER BY
  t0.priority ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.priority AS priority_3, t0.image AS image_4, t0.parent_id AS parent_id_5, t6.id AS id_7, t6.label AS label_8, t6.priority AS priority_9, t6.image AS image_10, t6.parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0.parent_id = t6.id WHERE t0.parent_id = 7 ORDER BY t0.priority ASC;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.priority AS priority_3,
  t0.image AS image_4,
  t0.parent_id AS parent_id_5,
  t6.id AS id_7,
  t6.label AS label_8,
  t6.priority AS priority_9,
  t6.image AS image_10,
  t6.parent_id AS parent_id_11
FROM
  product_category t0
  LEFT JOIN product_category t6 ON t0.parent_id = t6.id
WHERE
  t0.parent_id = ?
ORDER BY
  t0.priority ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.priority AS priority_3, t0.image AS image_4, t0.parent_id AS parent_id_5, t6.id AS id_7, t6.label AS label_8, t6.priority AS priority_9, t6.image AS image_10, t6.parent_id AS parent_id_11 FROM product_category t0 LEFT JOIN product_category t6 ON t0.parent_id = t6.id WHERE t0.parent_id = 8 ORDER BY t0.priority ASC;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.price AS price_3,
  t0.label AS label_4,
  t0.product_id AS product_id_5
FROM
  product_quantity t0
WHERE
  (
    t0.quantity >= ?
    AND t0.product_id = ?
  )
ORDER BY
  t0.quantity ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.label AS label_4, t0.product_id AS product_id_5 FROM product_quantity t0 WHERE (t0.quantity >= 1 AND t0.product_id = 1472) ORDER BY t0.quantity ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.price AS price_3,
  t0.label AS label_4,
  t0.product_id AS product_id_5
FROM
  product_quantity t0
WHERE
  (
    t0.quantity >= ?
    AND t0.product_id = ?
  )
ORDER BY
  t0.quantity ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.label AS label_4, t0.product_id AS product_id_5 FROM product_quantity t0 WHERE (t0.quantity >= 1 AND t0.product_id = 1473) ORDER BY t0.quantity ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.price AS price_3,
  t0.label AS label_4,
  t0.product_id AS product_id_5
FROM
  product_quantity t0
WHERE
  (
    t0.quantity >= ?
    AND t0.product_id = ?
  )
ORDER BY
  t0.quantity ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.label AS label_4, t0.product_id AS product_id_5 FROM product_quantity t0 WHERE (t0.quantity >= 1 AND t0.product_id = 1474) ORDER BY t0.quantity ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.price AS price_3,
  t0.label AS label_4,
  t0.product_id AS product_id_5
FROM
  product_quantity t0
WHERE
  (
    t0.quantity >= ?
    AND t0.product_id = ?
  )
ORDER BY
  t0.quantity ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.label AS label_4, t0.product_id AS product_id_5 FROM product_quantity t0 WHERE (t0.quantity >= 1 AND t0.product_id = 1475) ORDER BY t0.quantity ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.price AS price_3,
  t0.label AS label_4,
  t0.product_id AS product_id_5
FROM
  product_quantity t0
WHERE
  (
    t0.quantity >= ?
    AND t0.product_id = ?
  )
ORDER BY
  t0.quantity ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.label AS label_4, t0.product_id AS product_id_5 FROM product_quantity t0 WHERE (t0.quantity >= 1 AND t0.product_id = 1476) ORDER BY t0.quantity ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.price AS price_3,
  t0.label AS label_4,
  t0.product_id AS product_id_5
FROM
  product_quantity t0
WHERE
  (
    t0.quantity >= ?
    AND t0.product_id = ?
  )
ORDER BY
  t0.quantity ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.label AS label_4, t0.product_id AS product_id_5 FROM product_quantity t0 WHERE (t0.quantity >= 1 AND t0.product_id = 1477) ORDER BY t0.quantity ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.price AS price_3,
  t0.label AS label_4,
  t0.product_id AS product_id_5
FROM
  product_quantity t0
WHERE
  (
    t0.quantity >= ?
    AND t0.product_id = ?
  )
ORDER BY
  t0.quantity ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.label AS label_4, t0.product_id AS product_id_5 FROM product_quantity t0 WHERE (t0.quantity >= 1 AND t0.product_id = 1478) ORDER BY t0.quantity ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.price AS price_3,
  t0.label AS label_4,
  t0.product_id AS product_id_5
FROM
  product_quantity t0
WHERE
  (
    t0.quantity >= ?
    AND t0.product_id = ?
  )
ORDER BY
  t0.quantity ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.label AS label_4, t0.product_id AS product_id_5 FROM product_quantity t0 WHERE (t0.quantity >= 1 AND t0.product_id = 1479) ORDER BY t0.quantity ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.price AS price_3,
  t0.label AS label_4,
  t0.product_id AS product_id_5
FROM
  product_quantity t0
WHERE
  (
    t0.quantity >= ?
    AND t0.product_id = ?
  )
ORDER BY
  t0.quantity ASC
LIMIT
  1