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 = 1293;

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 (1293);

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 (1293, 1292, 12) ORDER BY c0_.sort_order ASC, c0_.name_en ASC, c1_.position ASC, c1_.id ASC;

SELECT
  p0_.id AS id_0,
  p0_.short_description AS short_description_1,
  p0_.slug AS slug_2,
  p0_.full_description AS full_description_3,
  p0_.tags AS tags_4,
  p0_.catalog_number AS catalog_number_5,
  p0_.oem_number AS oem_number_6,
  p0_.article_number AS article_number_7,
  p0_.condition_type AS condition_type_8,
  p0_.price AS price_9,
  p0_.price_new AS price_new_10,
  p0_.quantity AS quantity_11,
  p0_.status AS status_12,
  p0_.created_at AS created_at_13,
  p1_.id AS id_14,
  p1_.image_name AS image_name_15,
  p1_.sort_order AS sort_order_16,
  p2_.id AS id_17,
  p2_.name AS name_18,
  p2_.slug AS slug_19,
  p2_.image_name AS image_name_20,
  m3_.id AS id_21,
  m3_.name AS name_22,
  m3_.slug AS slug_23,
  m3_.ext_source AS ext_source_24,
  m3_.ext_id AS ext_id_25,
  m4_.id AS id_26,
  m4_.name AS name_27,
  m4_.slug AS slug_28,
  m4_.ext_id AS ext_id_29,
  v5_.id AS id_30,
  v5_.year_from AS year_from_31,
  v5_.year_to AS year_to_32,
  v5_.generation_name AS generation_name_33,
  p6_.id AS id_34,
  p6_.value_text AS value_text_35,
  p6_.value_number_from AS value_number_from_36,
  p6_.value_number_to AS value_number_to_37,
  p6_.value_json AS value_json_38,
  c7_.id AS id_39,
  c7_.code AS code_40,
  c7_.name_en AS name_en_41,
  c7_.name_es AS name_es_42,
  c7_.type AS type_43,
  c7_.sort_order AS sort_order_44,
  p0_.owner_id AS owner_id_45,
  p0_.make_id AS make_id_46,
  p0_.model_id AS model_id_47,
  p0_.vehicle_range_id AS vehicle_range_id_48,
  p0_.part_category_id AS part_category_id_49,
  p0_.dismantled_vehicle_id AS dismantled_vehicle_id_50,
  p1_.listing_id AS listing_id_51,
  p2_.parent_id AS parent_id_52,
  m4_.make_id AS make_id_53,
  v5_.model_id AS model_id_54,
  p6_.listing_id AS listing_id_55,
  p6_.filter_id AS filter_id_56
FROM
  part_listings p0_
  LEFT JOIN part_listing_images p1_ ON p0_.id = p1_.listing_id
  LEFT JOIN part_categories p2_ ON p0_.part_category_id = p2_.id
  LEFT JOIN makes m3_ ON p0_.make_id = m3_.id
  LEFT JOIN models m4_ ON p0_.model_id = m4_.id
  LEFT JOIN vehicle_ranges v5_ ON p0_.vehicle_range_id = v5_.id
  LEFT JOIN part_listing_custom_filter_values p6_ ON p0_.id = p6_.listing_id
  LEFT JOIN custom_filters c7_ ON p6_.filter_id = c7_.id
  INNER JOIN users u8_ ON p0_.owner_id = u8_.id
  INNER JOIN company_profiles c9_ ON u8_.id = c9_.user_id
WHERE
  p0_.status = ?
  AND c9_.status = ?
  AND p0_.quantity > 0
  AND p2_.id IN (?)
ORDER BY
  p0_.created_at DESC

SELECT p0_.id AS id_0, p0_.short_description AS short_description_1, p0_.slug AS slug_2, p0_.full_description AS full_description_3, p0_.tags AS tags_4, p0_.catalog_number AS catalog_number_5, p0_.oem_number AS oem_number_6, p0_.article_number AS article_number_7, p0_.condition_type AS condition_type_8, p0_.price AS price_9, p0_.price_new AS price_new_10, p0_.quantity AS quantity_11, p0_.status AS status_12, p0_.created_at AS created_at_13, p1_.id AS id_14, p1_.image_name AS image_name_15, p1_.sort_order AS sort_order_16, p2_.id AS id_17, p2_.name AS name_18, p2_.slug AS slug_19, p2_.image_name AS image_name_20, m3_.id AS id_21, m3_.name AS name_22, m3_.slug AS slug_23, m3_.ext_source AS ext_source_24, m3_.ext_id AS ext_id_25, m4_.id AS id_26, m4_.name AS name_27, m4_.slug AS slug_28, m4_.ext_id AS ext_id_29, v5_.id AS id_30, v5_.year_from AS year_from_31, v5_.year_to AS year_to_32, v5_.generation_name AS generation_name_33, p6_.id AS id_34, p6_.value_text AS value_text_35, p6_.value_number_from AS value_number_from_36, p6_.value_number_to AS value_number_to_37, p6_.value_json AS value_json_38, c7_.id AS id_39, c7_.code AS code_40, c7_.name_en AS name_en_41, c7_.name_es AS name_es_42, c7_.type AS type_43, c7_.sort_order AS sort_order_44, p0_.owner_id AS owner_id_45, p0_.make_id AS make_id_46, p0_.model_id AS model_id_47, p0_.vehicle_range_id AS vehicle_range_id_48, p0_.part_category_id AS part_category_id_49, p0_.dismantled_vehicle_id AS dismantled_vehicle_id_50, p1_.listing_id AS listing_id_51, p2_.parent_id AS parent_id_52, m4_.make_id AS make_id_53, v5_.model_id AS model_id_54, p6_.listing_id AS listing_id_55, p6_.filter_id AS filter_id_56 FROM part_listings p0_ LEFT JOIN part_listing_images p1_ ON p0_.id = p1_.listing_id LEFT JOIN part_categories p2_ ON p0_.part_category_id = p2_.id LEFT JOIN makes m3_ ON p0_.make_id = m3_.id LEFT JOIN models m4_ ON p0_.model_id = m4_.id LEFT JOIN vehicle_ranges v5_ ON p0_.vehicle_range_id = v5_.id LEFT JOIN part_listing_custom_filter_values p6_ ON p0_.id = p6_.listing_id LEFT JOIN custom_filters c7_ ON p6_.filter_id = c7_.id INNER JOIN users u8_ ON p0_.owner_id = u8_.id INNER JOIN company_profiles c9_ ON u8_.id = c9_.user_id WHERE p0_.status = 'active' AND c9_.status = 'active' AND p0_.quantity > 0 AND p2_.id IN (1293) ORDER BY p0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.ext_source AS ext_source_4,
  t0.ext_id AS ext_id_5
FROM
  makes t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.ext_source AS ext_source_4, t0.ext_id AS ext_id_5 FROM makes t0 ORDER BY t0.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.company_name AS company_name_1,
  c0_.logo_name AS logo_name_2,
  c0_.ein AS ein_3,
  c0_.status AS status_4,
  c0_.submitted_at AS submitted_at_5,
  c0_.reviewed_at AS reviewed_at_6,
  u1_.id AS id_7,
  u1_.email AS email_8,
  u1_.roles AS roles_9,
  u1_.password AS password_10,
  u1_.is_verified AS is_verified_11,
  u1_.phone AS phone_12,
  u1_.address_line1 AS address_line1_13,
  u1_.address_line2 AS address_line2_14,
  u1_.city AS city_15,
  u1_.state AS state_16,
  u1_.postal_code AS postal_code_17,
  u1_.is_company AS is_company_18,
  c0_.user_id AS user_id_19
FROM
  company_profiles c0_
  INNER JOIN users u1_ ON c0_.user_id = u1_.id
WHERE
  c0_.status = ?
  AND c0_.company_name IS NOT NULL
  AND TRIM(c0_.company_name) <> ''
ORDER BY
  c0_.company_name ASC

SELECT c0_.id AS id_0, c0_.company_name AS company_name_1, c0_.logo_name AS logo_name_2, c0_.ein AS ein_3, c0_.status AS status_4, c0_.submitted_at AS submitted_at_5, c0_.reviewed_at AS reviewed_at_6, u1_.id AS id_7, u1_.email AS email_8, u1_.roles AS roles_9, u1_.password AS password_10, u1_.is_verified AS is_verified_11, u1_.phone AS phone_12, u1_.address_line1 AS address_line1_13, u1_.address_line2 AS address_line2_14, u1_.city AS city_15, u1_.state AS state_16, u1_.postal_code AS postal_code_17, u1_.is_company AS is_company_18, c0_.user_id AS user_id_19 FROM company_profiles c0_ INNER JOIN users u1_ ON c0_.user_id = u1_.id WHERE c0_.status = 'active' AND c0_.company_name IS NOT NULL AND TRIM(c0_.company_name) <> '' ORDER BY c0_.company_name ASC;