Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image_name AS image_name_4,
  t0.parent_id AS parent_id_5
FROM
  part_categories t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_name AS image_name_4, t0.parent_id AS parent_id_5 FROM part_categories t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image_name AS image_name_4,
  t0.parent_id AS parent_id_5
FROM
  part_categories t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_name AS image_name_4, t0.parent_id AS parent_id_5 FROM part_categories t0 ORDER BY t0.name ASC;

SELECT
  p0_.part_category_id AS sclr_0,
  COUNT(p0_.id) AS sclr_1
FROM
  part_listings p0_
  LEFT JOIN part_categories p1_ ON p0_.part_category_id = p1_.id
  LEFT JOIN makes m2_ ON p0_.make_id = m2_.id
  LEFT JOIN models m3_ ON p0_.model_id = m3_.id
  LEFT JOIN vehicle_ranges v4_ ON p0_.vehicle_range_id = v4_.id
  INNER JOIN users u5_ ON p0_.owner_id = u5_.id
  INNER JOIN company_profiles c6_ ON u5_.id = c6_.user_id
WHERE
  p0_.status = ?
  AND c6_.status = ?
  AND p0_.quantity > 0
  AND p0_.part_category_id IS NOT NULL
GROUP BY
  p0_.part_category_id

SELECT p0_.part_category_id AS sclr_0, COUNT(p0_.id) AS sclr_1 FROM part_listings p0_ LEFT JOIN part_categories p1_ ON p0_.part_category_id = p1_.id LEFT JOIN makes m2_ ON p0_.make_id = m2_.id LEFT JOIN models m3_ ON p0_.model_id = m3_.id LEFT JOIN vehicle_ranges v4_ ON p0_.vehicle_range_id = v4_.id INNER JOIN users u5_ ON p0_.owner_id = u5_.id INNER JOIN company_profiles c6_ ON u5_.id = c6_.user_id WHERE p0_.status = 'active' AND c6_.status = 'active' AND p0_.quantity > 0 AND p0_.part_category_id IS NOT NULL GROUP BY p0_.part_category_id;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image_name AS image_name_4,
  t0.parent_id AS parent_id_5
FROM
  part_categories t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_name AS image_name_4, t0.parent_id AS parent_id_5 FROM part_categories t0 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.image_name AS image_name_4,
  t0.parent_id AS parent_id_5
FROM
  part_categories t0
WHERE
  t0.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_name AS image_name_4, t0.parent_id AS parent_id_5 FROM part_categories t0 WHERE t0.id IN (4, 195, 203, 202, 201, 200, 199, 198, 197, 196, 185, 194, 193, 192, 191, 190, 189, 188, 187, 186, 174, 183, 182, 181, 184, 180, 179, 178, 177, 176, 175, 167, 173, 172, 171, 170, 169, 168, 148, 166, 165, 164, 163, 162, 161, 160, 159, 158, 157, 156, 155, 154, 153, 152, 151, 150, 149, 134, 147, 146, 145, 144, 143, 142, 141, 140, 139, 138, 137, 136, 135, 115, 133, 132, 131, 130, 129, 128, 127, 126, 125, 124, 123, 122, 121, 120, 119, 118, 117, 116, 95, 114, 113, 112, 111, 110, 109, 108, 1895, 107, 106, 105, 104, 103, 102, 101, 100, 1887, 1886, 99, 1894, 98, 97, 96);

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.name_en AS name_en_2,
  c0_.name_es AS name_es_3,
  c0_.type AS type_4,
  c0_.sort_order AS sort_order_5,
  c1_.id AS id_6,
  c1_.value AS value_7,
  c1_.label_en AS label_en_8,
  c1_.label_es AS label_es_9,
  c1_.position AS position_10,
  c1_.filter_id AS filter_id_11
FROM
  custom_filters c0_
  INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id
  INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id
  LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id
WHERE
  p2_.id IN (?)
ORDER BY
  c0_.sort_order ASC,
  c0_.name_en ASC,
  c1_.position ASC,
  c1_.id ASC

SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (4) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC;

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.name_en AS name_en_2,
  c0_.name_es AS name_es_3,
  c0_.type AS type_4,
  c0_.sort_order AS sort_order_5,
  c1_.id AS id_6,
  c1_.value AS value_7,
  c1_.label_en AS label_en_8,
  c1_.label_es AS label_es_9,
  c1_.position AS position_10,
  c1_.filter_id AS filter_id_11
FROM
  custom_filters c0_
  INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id
  INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id
  LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id
WHERE
  p2_.id IN (?, ?)
ORDER BY
  c0_.sort_order ASC,
  c0_.name_en ASC,
  c1_.position ASC,
  c1_.id ASC

SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (95, 4) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC;

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.name_en AS name_en_2,
  c0_.name_es AS name_es_3,
  c0_.type AS type_4,
  c0_.sort_order AS sort_order_5,
  c1_.id AS id_6,
  c1_.value AS value_7,
  c1_.label_en AS label_en_8,
  c1_.label_es AS label_es_9,
  c1_.position AS position_10,
  c1_.filter_id AS filter_id_11
FROM
  custom_filters c0_
  INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id
  INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id
  LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id
WHERE
  p2_.id IN (?, ?, ?)
ORDER BY
  c0_.sort_order ASC,
  c0_.name_en ASC,
  c1_.position ASC,
  c1_.id ASC

SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (96, 95, 4) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC;

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.name_en AS name_en_2,
  c0_.name_es AS name_es_3,
  c0_.type AS type_4,
  c0_.sort_order AS sort_order_5,
  c1_.id AS id_6,
  c1_.value AS value_7,
  c1_.label_en AS label_en_8,
  c1_.label_es AS label_es_9,
  c1_.position AS position_10,
  c1_.filter_id AS filter_id_11
FROM
  custom_filters c0_
  INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id
  INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id
  LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id
WHERE
  p2_.id IN (?, ?, ?)
ORDER BY
  c0_.sort_order ASC,
  c0_.name_en ASC,
  c1_.position ASC,
  c1_.id ASC

SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (97, 95, 4) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC;

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.name_en AS name_en_2,
  c0_.name_es AS name_es_3,
  c0_.type AS type_4,
  c0_.sort_order AS sort_order_5,
  c1_.id AS id_6,
  c1_.value AS value_7,
  c1_.label_en AS label_en_8,
  c1_.label_es AS label_es_9,
  c1_.position AS position_10,
  c1_.filter_id AS filter_id_11
FROM
  custom_filters c0_
  INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id
  INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id
  LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id
WHERE
  p2_.id IN (?, ?, ?)
ORDER BY
  c0_.sort_order ASC,
  c0_.name_en ASC,
  c1_.position ASC,
  c1_.id ASC

SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (98, 95, 4) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC;

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.name_en AS name_en_2,
  c0_.name_es AS name_es_3,
  c0_.type AS type_4,
  c0_.sort_order AS sort_order_5,
  c1_.id AS id_6,
  c1_.value AS value_7,
  c1_.label_en AS label_en_8,
  c1_.label_es AS label_es_9,
  c1_.position AS position_10,
  c1_.filter_id AS filter_id_11
FROM
  custom_filters c0_
  INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id
  INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id
  LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id
WHERE
  p2_.id IN (?, ?, ?)
ORDER BY
  c0_.sort_order ASC,
  c0_.name_en ASC,
  c1_.position ASC,
  c1_.id ASC

SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (99, 95, 4) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC;

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.name_en AS name_en_2,
  c0_.name_es AS name_es_3,
  c0_.type AS type_4,
  c0_.sort_order AS sort_order_5,
  c1_.id AS id_6,
  c1_.value AS value_7,
  c1_.label_en AS label_en_8,
  c1_.label_es AS label_es_9,
  c1_.position AS position_10,
  c1_.filter_id AS filter_id_11
FROM
  custom_filters c0_
  INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id
  INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id
  LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id
WHERE
  p2_.id IN (?, ?, ?)
ORDER BY
  c0_.sort_order ASC,
  c0_.name_en ASC,
  c1_.position ASC,
  c1_.id ASC

SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (100, 95, 4) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC;

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.name_en AS name_en_2,
  c0_.name_es AS name_es_3,
  c0_.type AS type_4,
  c0_.sort_order AS sort_order_5,
  c1_.id AS id_6,
  c1_.value AS value_7,
  c1_.label_en AS label_en_8,
  c1_.label_es AS label_es_9,
  c1_.position AS position_10,
  c1_.filter_id AS filter_id_11
FROM
  custom_filters c0_
  INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id
  INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id
  LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id
WHERE
  p2_.id IN (?, ?, ?)
ORDER BY
  c0_.sort_order ASC,
  c0_.name_en ASC,
  c1_.position ASC,
  c1_.id ASC

SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (101, 95, 4) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC;

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.name_en AS name_en_2,
  c0_.name_es AS name_es_3,
  c0_.type AS type_4,
  c0_.sort_order AS sort_order_5,
  c1_.id AS id_6,
  c1_.value AS value_7,
  c1_.label_en AS label_en_8,
  c1_.label_es AS label_es_9,
  c1_.position AS position_10,
  c1_.filter_id AS filter_id_11
FROM
  custom_filters c0_
  INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id
  INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id
  LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id
WHERE
  p2_.id IN (?, ?, ?)
ORDER BY
  c0_.sort_order ASC,
  c0_.name_en ASC,
  c1_.position ASC,
  c1_.id ASC

SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (102, 95, 4) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC;

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.name_en AS name_en_2,
  c0_.name_es AS name_es_3,
  c0_.type AS type_4,
  c0_.sort_order AS sort_order_5,
  c1_.id AS id_6,
  c1_.value AS value_7,
  c1_.label_en AS label_en_8,
  c1_.label_es AS label_es_9,
  c1_.position AS position_10,
  c1_.filter_id AS filter_id_11
FROM
  custom_filters c0_
  INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id
  INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id
  LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id
WHERE
  p2_.id IN (?, ?, ?)
ORDER BY
  c0_.sort_order ASC,
  c0_.name_en ASC,
  c1_.position ASC,
  c1_.id ASC

SELECT DISTINCT c0_.id AS id_0, c0_.code AS code_1, c0_.name_en AS name_en_2, c0_.name_es AS name_es_3, c0_.type AS type_4, c0_.sort_order AS sort_order_5, c1_.id AS id_6, c1_.value AS value_7, c1_.label_en AS label_en_8, c1_.label_es AS label_es_9, c1_.position AS position_10, c1_.filter_id AS filter_id_11 FROM custom_filters c0_ INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id WHERE p2_.id IN (103, 95, 4) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC;

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.code AS code_1,
  c0_.name_en AS name_en_2,
  c0_.name_es AS name_es_3,
  c0_.type AS type_4,
  c0_.sort_order AS sort_order_5,
  c1_.id AS id_6,
  c1_.value AS value_7,
  c1_.label_en AS label_en_8,
  c1_.label_es AS label_es_9,
  c1_.position AS position_10,
  c1_.filter_id AS filter_id_11
FROM
  custom_filters c0_
  INNER JOIN part_category_custom_filters p3_ ON c0_.id = p3_.custom_filter_id
  INNER JOIN part_categories p2_ ON p2_.id = p3_.part_category_id
  LEFT JOIN custom_filter_options c1_ ON c0_.id = c1_.filter_id
WHERE
  p2_.id IN (?, ?, ?)
ORDER BY
  c0_.sort_order ASC,
  c0_.name_en ASC,
  c1_.position ASC,
  c1_.id ASC