Symfony Profiler

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.roles AS roles_2,
  u0_.password AS password_3,
  u0_.is_verified AS is_verified_4,
  u0_.phone AS phone_5,
  u0_.address_line1 AS address_line1_6,
  u0_.address_line2 AS address_line2_7,
  u0_.city AS city_8,
  u0_.state AS state_9,
  u0_.postal_code AS postal_code_10,
  u0_.is_company AS is_company_11,
  c1_.id AS id_12,
  c1_.company_name AS company_name_13,
  c1_.logo_name AS logo_name_14,
  c1_.ein AS ein_15,
  c1_.status AS status_16,
  c1_.submitted_at AS submitted_at_17,
  c1_.reviewed_at AS reviewed_at_18,
  c1_.user_id AS user_id_19
FROM
  users u0_
  INNER JOIN company_profiles c1_ ON u0_.id = c1_.user_id
WHERE
  u0_.id = ?
  AND c1_.status = ?

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.is_verified AS is_verified_4, u0_.phone AS phone_5, u0_.address_line1 AS address_line1_6, u0_.address_line2 AS address_line2_7, u0_.city AS city_8, u0_.state AS state_9, u0_.postal_code AS postal_code_10, u0_.is_company AS is_company_11, c1_.id AS id_12, c1_.company_name AS company_name_13, c1_.logo_name AS logo_name_14, c1_.ein AS ein_15, c1_.status AS status_16, c1_.submitted_at AS submitted_at_17, c1_.reviewed_at AS reviewed_at_18, c1_.user_id AS user_id_19 FROM users u0_ INNER JOIN company_profiles c1_ ON u0_.id = c1_.user_id WHERE u0_.id = 1 AND c1_.status = 'active';

SELECT
  DISTINCT m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.slug AS slug_2,
  m0_.ext_source AS ext_source_3,
  m0_.ext_id AS ext_id_4
FROM
  makes m0_
  INNER JOIN part_listings p1_ ON (
    p1_.make_id = m0_.id
    AND p1_.quantity > 0
  )
  INNER JOIN users u2_ ON p1_.owner_id = u2_.id
  INNER JOIN company_profiles c3_ ON u2_.id = c3_.user_id
WHERE
  c3_.status = ?
  AND u2_.id = ?
ORDER BY
  m0_.name ASC

SELECT DISTINCT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2, m0_.ext_source AS ext_source_3, m0_.ext_id AS ext_id_4 FROM makes m0_ INNER JOIN part_listings p1_ ON (p1_.make_id = m0_.id AND p1_.quantity > 0) INNER JOIN users u2_ ON p1_.owner_id = u2_.id INNER JOIN company_profiles c3_ ON u2_.id = c3_.user_id WHERE c3_.status = 'active' AND u2_.id = 1 ORDER BY m0_.name ASC;

SELECT
  COUNT(s0_.id) AS sclr_0
FROM
  seller_reviews s0_
  INNER JOIN users u1_ ON s0_.seller_id = u1_.id
WHERE
  u1_.id = ?
  AND s0_.status = ?

SELECT COUNT(s0_.id) AS sclr_0 FROM seller_reviews s0_ INNER JOIN users u1_ ON s0_.seller_id = u1_.id WHERE u1_.id = 1 AND s0_.status = 'active';

SELECT
  COALESCE(
    AVG(s0_.rating),
    0
  ) AS sclr_0
FROM
  seller_reviews s0_
  INNER JOIN users u1_ ON s0_.seller_id = u1_.id
WHERE
  u1_.id = ?
  AND s0_.status = ?

SELECT COALESCE(AVG(s0_.rating), 0) AS sclr_0 FROM seller_reviews s0_ INNER JOIN users u1_ ON s0_.seller_id = u1_.id WHERE u1_.id = 1 AND s0_.status = 'active';

SELECT
  s0_.id AS id_0,
  s0_.rating AS rating_1,
  s0_.message AS message_2,
  s0_.status AS status_3,
  s0_.created_at AS created_at_4,
  s0_.updated_at AS updated_at_5,
  s0_.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,
  u2_.id AS id_19,
  u2_.email AS email_20,
  u2_.roles AS roles_21,
  u2_.password AS password_22,
  u2_.is_verified AS is_verified_23,
  u2_.phone AS phone_24,
  u2_.address_line1 AS address_line1_25,
  u2_.address_line2 AS address_line2_26,
  u2_.city AS city_27,
  u2_.state AS state_28,
  u2_.postal_code AS postal_code_29,
  u2_.is_company AS is_company_30,
  o3_.id AS id_31,
  o3_.order_index AS order_index_32,
  o3_.delivery_address AS delivery_address_33,
  o3_.phone AS phone_34,
  o3_.email AS email_35,
  o3_.delivery_method AS delivery_method_36,
  o3_.delivery_price AS delivery_price_37,
  o3_.subtotal AS subtotal_38,
  o3_.total AS total_39,
  o3_.status AS status_40,
  o3_.created_at AS created_at_41,
  s0_.order_id AS order_id_42,
  s0_.buyer_id AS buyer_id_43,
  s0_.seller_id AS seller_id_44,
  o3_.buyer_id AS buyer_id_45
FROM
  seller_reviews s0_
  INNER JOIN users u1_ ON s0_.buyer_id = u1_.id
  INNER JOIN users u2_ ON s0_.seller_id = u2_.id
  INNER JOIN `orders` o3_ ON s0_.order_id = o3_.id
WHERE
  u2_.id = ?
  AND s0_.status = ?
ORDER BY
  s0_.created_at DESC
LIMIT
  10

SELECT s0_.id AS id_0, s0_.rating AS rating_1, s0_.message AS message_2, s0_.status AS status_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.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, u2_.id AS id_19, u2_.email AS email_20, u2_.roles AS roles_21, u2_.password AS password_22, u2_.is_verified AS is_verified_23, u2_.phone AS phone_24, u2_.address_line1 AS address_line1_25, u2_.address_line2 AS address_line2_26, u2_.city AS city_27, u2_.state AS state_28, u2_.postal_code AS postal_code_29, u2_.is_company AS is_company_30, o3_.id AS id_31, o3_.order_index AS order_index_32, o3_.delivery_address AS delivery_address_33, o3_.phone AS phone_34, o3_.email AS email_35, o3_.delivery_method AS delivery_method_36, o3_.delivery_price AS delivery_price_37, o3_.subtotal AS subtotal_38, o3_.total AS total_39, o3_.status AS status_40, o3_.created_at AS created_at_41, s0_.order_id AS order_id_42, s0_.buyer_id AS buyer_id_43, s0_.seller_id AS seller_id_44, o3_.buyer_id AS buyer_id_45 FROM seller_reviews s0_ INNER JOIN users u1_ ON s0_.buyer_id = u1_.id INNER JOIN users u2_ ON s0_.seller_id = u2_.id INNER JOIN `orders` o3_ ON s0_.order_id = o3_.id WHERE u2_.id = 1 AND s0_.status = 'active' ORDER BY s0_.created_at DESC LIMIT 10;

SELECT
  t0.id AS id_1,
  t0.company_name AS company_name_2,
  t0.logo_name AS logo_name_3,
  t0.ein AS ein_4,
  t0.status AS status_5,
  t0.submitted_at AS submitted_at_6,
  t0.reviewed_at AS reviewed_at_7,
  t0.user_id AS user_id_8
FROM
  company_profiles t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.logo_name AS logo_name_3, t0.ein AS ein_4, t0.status AS status_5, t0.submitted_at AS submitted_at_6, t0.reviewed_at AS reviewed_at_7, t0.user_id AS user_id_8 FROM company_profiles t0 WHERE t0.user_id = 10;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.slug AS slug_2,
  a0_.description AS description_3,
  a0_.street_address AS street_address_4,
  a0_.address_line2 AS address_line2_5,
  a0_.city AS city_6,
  a0_.state AS state_7,
  a0_.postal_code AS postal_code_8,
  a0_.country_code AS country_code_9,
  a0_.latitude AS latitude_10,
  a0_.longitude AS longitude_11,
  a0_.created_at AS created_at_12,
  a1_.id AS id_13,
  a1_.image_name AS image_name_14,
  a2_.id AS id_15,
  a2_.label AS label_16,
  a2_.phone_number AS phone_number_17,
  a2_.comment AS comment_18,
  a2_.position AS position_19,
  a0_.owner_id AS owner_id_20,
  a1_.dismantling_id AS dismantling_id_21,
  a2_.dismantling_id AS dismantling_id_22
FROM
  auto_dismantlings a0_
  LEFT JOIN users u3_ ON a0_.owner_id = u3_.id
  LEFT JOIN auto_dismantling_photos a1_ ON a0_.id = a1_.dismantling_id
  LEFT JOIN auto_dismantling_phones a2_ ON a0_.id = a2_.dismantling_id
WHERE
  u3_.id = ?
ORDER BY
  a0_.created_at DESC,
  a0_.id DESC,
  a2_.position ASC,
  a2_.id ASC
LIMIT
  6

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.description AS description_3, a0_.street_address AS street_address_4, a0_.address_line2 AS address_line2_5, a0_.city AS city_6, a0_.state AS state_7, a0_.postal_code AS postal_code_8, a0_.country_code AS country_code_9, a0_.latitude AS latitude_10, a0_.longitude AS longitude_11, a0_.created_at AS created_at_12, a1_.id AS id_13, a1_.image_name AS image_name_14, a2_.id AS id_15, a2_.label AS label_16, a2_.phone_number AS phone_number_17, a2_.comment AS comment_18, a2_.position AS position_19, a0_.owner_id AS owner_id_20, a1_.dismantling_id AS dismantling_id_21, a2_.dismantling_id AS dismantling_id_22 FROM auto_dismantlings a0_ LEFT JOIN users u3_ ON a0_.owner_id = u3_.id LEFT JOIN auto_dismantling_photos a1_ ON a0_.id = a1_.dismantling_id LEFT JOIN auto_dismantling_phones a2_ ON a0_.id = a2_.dismantling_id WHERE u3_.id = 1 ORDER BY a0_.created_at DESC, a0_.id DESC, a2_.position ASC, a2_.id ASC LIMIT 6;

SELECT
  d0_.id AS id_0
FROM
  dismantled_vehicles d0_
  LEFT JOIN users u1_ ON d0_.owner_id = u1_.id
WHERE
  u1_.id = ?
ORDER BY
  d0_.created_at DESC,
  d0_.id DESC
LIMIT
  8

SELECT d0_.id AS id_0 FROM dismantled_vehicles d0_ LEFT JOIN users u1_ ON d0_.owner_id = u1_.id WHERE u1_.id = 1 ORDER BY d0_.created_at DESC, d0_.id DESC LIMIT 8;

SELECT
  DISTINCT d0_.id AS id_0,
  d0_.description AS description_1,
  d0_.year AS year_2,
  d0_.engine_volume AS engine_volume_3,
  d0_.drivetrain AS drivetrain_4,
  d0_.fuel_type AS fuel_type_5,
  d0_.transmission_type AS transmission_type_6,
  d0_.vin AS vin_7,
  d0_.stock_number AS stock_number_8,
  d0_.slug AS slug_9,
  d0_.address AS address_10,
  d0_.created_at AS created_at_11,
  d1_.id AS id_12,
  d1_.image_name AS image_name_13,
  d1_.sort_order AS sort_order_14,
  m2_.id AS id_15,
  m2_.name AS name_16,
  m2_.slug AS slug_17,
  m2_.ext_source AS ext_source_18,
  m2_.ext_id AS ext_id_19,
  m3_.id AS id_20,
  m3_.name AS name_21,
  m3_.slug AS slug_22,
  m3_.ext_id AS ext_id_23,
  v4_.id AS id_24,
  v4_.year_from AS year_from_25,
  v4_.year_to AS year_to_26,
  v4_.generation_name AS generation_name_27,
  a5_.id AS id_28,
  a5_.name AS name_29,
  a5_.slug AS slug_30,
  a5_.description AS description_31,
  a5_.street_address AS street_address_32,
  a5_.address_line2 AS address_line2_33,
  a5_.city AS city_34,
  a5_.state AS state_35,
  a5_.postal_code AS postal_code_36,
  a5_.country_code AS country_code_37,
  a5_.latitude AS latitude_38,
  a5_.longitude AS longitude_39,
  a5_.created_at AS created_at_40,
  a6_.id AS id_41,
  a6_.label AS label_42,
  a6_.phone_number AS phone_number_43,
  a6_.comment AS comment_44,
  a6_.position AS position_45,
  d7_.id AS id_46,
  d7_.label AS label_47,
  d7_.phone_number AS phone_number_48,
  d7_.comment AS comment_49,
  d7_.position AS position_50,
  d0_.owner_id AS owner_id_51,
  d0_.make_id AS make_id_52,
  d0_.model_id AS model_id_53,
  d0_.vehicle_range_id AS vehicle_range_id_54,
  d0_.auto_dismantling_id AS auto_dismantling_id_55,
  d1_.vehicle_id AS vehicle_id_56,
  m3_.make_id AS make_id_57,
  v4_.model_id AS model_id_58,
  a5_.owner_id AS owner_id_59,
  a6_.dismantling_id AS dismantling_id_60,
  d7_.vehicle_id AS vehicle_id_61
FROM
  dismantled_vehicles d0_
  LEFT JOIN dismantled_vehicle_photos d1_ ON d0_.id = d1_.vehicle_id
  LEFT JOIN makes m2_ ON d0_.make_id = m2_.id
  LEFT JOIN models m3_ ON d0_.model_id = m3_.id
  LEFT JOIN vehicle_ranges v4_ ON d0_.vehicle_range_id = v4_.id
  LEFT JOIN auto_dismantlings a5_ ON d0_.auto_dismantling_id = a5_.id
  LEFT JOIN auto_dismantling_phones a6_ ON a5_.id = a6_.dismantling_id
  LEFT JOIN dismantled_vehicle_phones d7_ ON d0_.id = d7_.vehicle_id
WHERE
  d0_.id IN (?, ?, ?, ?, ?, ?)
ORDER BY
  a6_.position ASC,
  a6_.id ASC,
  d7_.position ASC,
  d7_.id ASC

SELECT DISTINCT d0_.id AS id_0, d0_.description AS description_1, d0_.year AS year_2, d0_.engine_volume AS engine_volume_3, d0_.drivetrain AS drivetrain_4, d0_.fuel_type AS fuel_type_5, d0_.transmission_type AS transmission_type_6, d0_.vin AS vin_7, d0_.stock_number AS stock_number_8, d0_.slug AS slug_9, d0_.address AS address_10, d0_.created_at AS created_at_11, d1_.id AS id_12, d1_.image_name AS image_name_13, d1_.sort_order AS sort_order_14, m2_.id AS id_15, m2_.name AS name_16, m2_.slug AS slug_17, m2_.ext_source AS ext_source_18, m2_.ext_id AS ext_id_19, m3_.id AS id_20, m3_.name AS name_21, m3_.slug AS slug_22, m3_.ext_id AS ext_id_23, v4_.id AS id_24, v4_.year_from AS year_from_25, v4_.year_to AS year_to_26, v4_.generation_name AS generation_name_27, a5_.id AS id_28, a5_.name AS name_29, a5_.slug AS slug_30, a5_.description AS description_31, a5_.street_address AS street_address_32, a5_.address_line2 AS address_line2_33, a5_.city AS city_34, a5_.state AS state_35, a5_.postal_code AS postal_code_36, a5_.country_code AS country_code_37, a5_.latitude AS latitude_38, a5_.longitude AS longitude_39, a5_.created_at AS created_at_40, a6_.id AS id_41, a6_.label AS label_42, a6_.phone_number AS phone_number_43, a6_.comment AS comment_44, a6_.position AS position_45, d7_.id AS id_46, d7_.label AS label_47, d7_.phone_number AS phone_number_48, d7_.comment AS comment_49, d7_.position AS position_50, d0_.owner_id AS owner_id_51, d0_.make_id AS make_id_52, d0_.model_id AS model_id_53, d0_.vehicle_range_id AS vehicle_range_id_54, d0_.auto_dismantling_id AS auto_dismantling_id_55, d1_.vehicle_id AS vehicle_id_56, m3_.make_id AS make_id_57, v4_.model_id AS model_id_58, a5_.owner_id AS owner_id_59, a6_.dismantling_id AS dismantling_id_60, d7_.vehicle_id AS vehicle_id_61 FROM dismantled_vehicles d0_ LEFT JOIN dismantled_vehicle_photos d1_ ON d0_.id = d1_.vehicle_id LEFT JOIN makes m2_ ON d0_.make_id = m2_.id LEFT JOIN models m3_ ON d0_.model_id = m3_.id LEFT JOIN vehicle_ranges v4_ ON d0_.vehicle_range_id = v4_.id LEFT JOIN auto_dismantlings a5_ ON d0_.auto_dismantling_id = a5_.id LEFT JOIN auto_dismantling_phones a6_ ON a5_.id = a6_.dismantling_id LEFT JOIN dismantled_vehicle_phones d7_ ON d0_.id = d7_.vehicle_id WHERE d0_.id IN (19, 18, 17, 16, 2, 1) ORDER BY a6_.position ASC, a6_.id ASC, d7_.position ASC, d7_.id ASC;