Symfony Profiler

SELECT
  i0_.id AS id_0,
  p1_.content AS content_1,
  p1_.created_at AS created_at_2
FROM
  private_message p1_
  LEFT JOIN notification n2_ ON (p1_.id = n2_.content_id)
  LEFT JOIN offer o3_ ON (n2_.entity_id = o3_.id)
  LEFT JOIN inquiry i0_ ON (o3_.inquiry_id = i0_.id)
WHERE
  n2_.entity_type = ?
  AND i0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?
  )

SELECT i0_.id AS id_0, p1_.content AS content_1, p1_.created_at AS created_at_2 FROM private_message p1_ LEFT JOIN notification n2_ ON (p1_.id = n2_.content_id) LEFT JOIN offer o3_ ON (n2_.entity_id = o3_.id) LEFT JOIN inquiry i0_ ON (o3_.inquiry_id = i0_.id) WHERE n2_.entity_type = 'offer' AND i0_.id IN (47610, 47599, 47422, 47416, 47341, 46959, 46926, 46855, 46759, 46757, 45901, 45850, 45730, 45514, 45463, 45450, 45386, 45348, 45340, 45260, 45162, 45047, 44526, 44491, 43777, 43668, 43543, 43300, 43259, 43045, 42825, 42824, 42680, 42523, 42268, 41998, 41905, 41783, 41778, 41620, 41547, 41443, 41330, 41172, 41146, 41109, 41057, 40691, 40688, 40295);

SELECT
  i0_.id AS id_0,
  i0_.expiration_date AS expiration_date_1,
  i0_.status AS status_2,
  i0_.vin AS vin_3,
  i0_.model AS model_4,
  i0_.registration_number AS registration_number_5,
  i0_.notices AS notices_6,
  i0_.archived AS archived_7,
  i0_.file_upload_id AS file_upload_id_8,
  i0_.notices_fv AS notices_fv_9,
  i0_.parts_received_date AS parts_received_date_10,
  i0_.parts_issued_date AS parts_issued_date_11,
  i0_.is_parts_received AS is_parts_received_12,
  i0_.is_parts_issued AS is_parts_issued_13,
  i0_.buyer_status AS buyer_status_14,
  i0_.seller_status AS seller_status_15,
  i0_.created_at AS created_at_16,
  i0_.updated_at AS updated_at_17,
  i0_.active AS active_18,
  (
    SELECT
      COUNT(o1_.id) AS sclr_20
    FROM
      offer o1_
    WHERE
      i0_.id = o1_.inquiry_id
      AND o1_.supplier_id = 685
      AND o1_.chosen = ?
  ) AS sclr_19,
  (
    SELECT
      COUNT(o2_.id) AS sclr_22
    FROM
      offer o2_
    WHERE
      i0_.id = o2_.inquiry_id
      AND o2_.supplier_id = 685
      AND o2_.chosen = ?
  ) AS sclr_21,
  (
    SELECT
      COUNT(o3_.id) AS sclr_24
    FROM
      offer o3_
    WHERE
      i0_.id = o3_.inquiry_id
      AND o3_.supplier_id <> 685
      AND o3_.chosen = ?
  ) AS sclr_23
FROM
  inquiry i0_
WHERE
  i0_.archived = ?
  AND i0_.expiration_date < ?
HAVING
  sclr_19 > 0
  AND sclr_21 = 0
  AND sclr_23 > 0
ORDER BY
  i0_.id DESC
LIMIT
  10

SELECT i0_.id AS id_0, i0_.expiration_date AS expiration_date_1, i0_.status AS status_2, i0_.vin AS vin_3, i0_.model AS model_4, i0_.registration_number AS registration_number_5, i0_.notices AS notices_6, i0_.archived AS archived_7, i0_.file_upload_id AS file_upload_id_8, i0_.notices_fv AS notices_fv_9, i0_.parts_received_date AS parts_received_date_10, i0_.parts_issued_date AS parts_issued_date_11, i0_.is_parts_received AS is_parts_received_12, i0_.is_parts_issued AS is_parts_issued_13, i0_.buyer_status AS buyer_status_14, i0_.seller_status AS seller_status_15, i0_.created_at AS created_at_16, i0_.updated_at AS updated_at_17, i0_.active AS active_18, (SELECT COUNT(o1_.id) AS sclr_20 FROM offer o1_ WHERE i0_.id = o1_.inquiry_id AND o1_.supplier_id = 685 AND o1_.chosen = 0) AS sclr_19, (SELECT COUNT(o2_.id) AS sclr_22 FROM offer o2_ WHERE i0_.id = o2_.inquiry_id AND o2_.supplier_id = 685 AND o2_.chosen = 1) AS sclr_21, (SELECT COUNT(o3_.id) AS sclr_24 FROM offer o3_ WHERE i0_.id = o3_.inquiry_id AND o3_.supplier_id <> 685 AND o3_.chosen = 1) AS sclr_23 FROM inquiry i0_ WHERE i0_.archived = 0 AND i0_.expiration_date < '2026-03-30 11:16:27' HAVING sclr_19 > 0 AND sclr_21 = 0 AND sclr_23 > 0 ORDER BY i0_.id DESC LIMIT 10;

SELECT
  i0_.id AS id_0,
  n1_.entity_type AS entity_type_1,
  i2_.id AS id_2,
  c3_.username AS username_3,
  c3_.id AS id_4,
  n1_.read_at AS read_at_5,
  n1_.id AS id_6,
  c4_.company_name AS company_name_7,
  c4_.id AS id_8
FROM
  inquiry_discussion_entry i0_
  LEFT JOIN notification n1_ ON (i0_.id = n1_.content_id)
  LEFT JOIN inquiry i2_ ON (i0_.inquiry_id = i2_.id)
  LEFT JOIN customer c3_ ON (c3_.id = i0_.author_id)
  LEFT JOIN customer c4_ ON (c4_.id = n1_.recipient_id)
WHERE
  n1_.is_read = ?
  AND n1_.entity_type = ?

SELECT i0_.id AS id_0, n1_.entity_type AS entity_type_1, i2_.id AS id_2, c3_.username AS username_3, c3_.id AS id_4, n1_.read_at AS read_at_5, n1_.id AS id_6, c4_.company_name AS company_name_7, c4_.id AS id_8 FROM inquiry_discussion_entry i0_ LEFT JOIN notification n1_ ON (i0_.id = n1_.content_id) LEFT JOIN inquiry i2_ ON (i0_.inquiry_id = i2_.id) LEFT JOIN customer c3_ ON (c3_.id = i0_.author_id) LEFT JOIN customer c4_ ON (c4_.id = n1_.recipient_id) WHERE n1_.is_read = 0 AND n1_.entity_type = 'inquiry';

SELECT
  t0.id AS id_1,
  t0.retail_price AS retail_price_2,
  t0.discount AS discount_3,
  t0.delivery_price AS delivery_price_4,
  t0.total_price AS total_price_5,
  t0.status AS status_6,
  t0.chosen AS chosen_7,
  t0.price_after_discount AS price_after_discount_8,
  t0.notices AS notices_9,
  t0.comment AS comment_10,
  t0.is_rejected AS is_rejected_11,
  t0.state AS state_12,
  t0.payment_method AS payment_method_13,
  t0.choose_date AS choose_date_14,
  t0.delivery_time AS delivery_time_15,
  t0.parts_ordered AS parts_ordered_16,
  t0.file_upload_id AS file_upload_id_17,
  t0.ordered_date AS ordered_date_18,
  t0.request_invoice AS request_invoice_19,
  t0.send_date AS send_date_20,
  t0.parts_sended AS parts_sended_21,
  t0.order_mode AS order_mode_22,
  t0.seen_by_recipient AS seen_by_recipient_23,
  t0.created_at AS created_at_24,
  t0.updated_at AS updated_at_25,
  t0.active AS active_26,
  t0.supplier_id AS supplier_id_27,
  t0.inquiry_id AS inquiry_id_28,
  t0.invoice_file_id AS invoice_file_id_29,
  t0.contact_person_id AS contact_person_id_30,
  t0.created_by_id AS created_by_id_31,
  t0.updated_by_id AS updated_by_id_32
FROM
  offer t0
WHERE
  t0.inquiry_id = ?

SELECT t0.id AS id_1, t0.retail_price AS retail_price_2, t0.discount AS discount_3, t0.delivery_price AS delivery_price_4, t0.total_price AS total_price_5, t0.status AS status_6, t0.chosen AS chosen_7, t0.price_after_discount AS price_after_discount_8, t0.notices AS notices_9, t0.comment AS comment_10, t0.is_rejected AS is_rejected_11, t0.state AS state_12, t0.payment_method AS payment_method_13, t0.choose_date AS choose_date_14, t0.delivery_time AS delivery_time_15, t0.parts_ordered AS parts_ordered_16, t0.file_upload_id AS file_upload_id_17, t0.ordered_date AS ordered_date_18, t0.request_invoice AS request_invoice_19, t0.send_date AS send_date_20, t0.parts_sended AS parts_sended_21, t0.order_mode AS order_mode_22, t0.seen_by_recipient AS seen_by_recipient_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.active AS active_26, t0.supplier_id AS supplier_id_27, t0.inquiry_id AS inquiry_id_28, t0.invoice_file_id AS invoice_file_id_29, t0.contact_person_id AS contact_person_id_30, t0.created_by_id AS created_by_id_31, t0.updated_by_id AS updated_by_id_32 FROM offer t0 WHERE t0.inquiry_id = 47422;

SELECT
  t0.id AS id_1,
  t0.company_name AS company_name_2,
  t0.nip AS nip_3,
  t0.username AS username_4,
  t0.password AS password_5,
  t0.phone_number AS phone_number_6,
  t0.last_inquiry_date AS last_inquiry_date_7,
  t0.last_offer_date AS last_offer_date_8,
  t0.is_recipient AS is_recipient_9,
  t0.is_supplier AS is_supplier_10,
  t0.roles AS roles_11,
  t0.salt AS salt_12,
  t0.register_key AS register_key_13,
  t0.reset_password_key AS reset_password_key_14,
  t0.zip_code AS zip_code_15,
  t0.city AS city_16,
  t0.street AS street_17,
  t0.property_number AS property_number_18,
  t0.apartment_number AS apartment_number_19,
  t0.show_other_offers AS show_other_offers_20,
  t0.dont_show_company_name_other_offers AS dont_show_company_name_other_offers_21,
  t0.igp AS igp_22,
  t0.can_choose_suppliers AS can_choose_suppliers_23,
  t0.can_see_supplier_data AS can_see_supplier_data_24,
  t0.show_other_offers_before_purchase AS show_other_offers_before_purchase_25,
  t0.show_only_retail_price_and_delivery_date AS show_only_retail_price_and_delivery_date_26,
  t0.notifications_offer_notification AS notifications_offer_notification_27,
  t0.notifications_offer_mail AS notifications_offer_mail_28,
  t0.notifications_inquiry_notification AS notifications_inquiry_notification_29,
  t0.notifications_inquiry_mail AS notifications_inquiry_mail_30,
  t0.notifications_invoice_notification AS notifications_invoice_notification_31,
  t0.notifications_invoice_mail AS notifications_invoice_mail_32,
  t0.can_delete_private_messages AS can_delete_private_messages_33,
  t0.can_see_other_suppliers_of_his_makes AS can_see_other_suppliers_of_his_makes_34,
  t0.can_get_notifications_about_better_offer AS can_get_notifications_about_better_offer_35,
  t0.delivery_for_whole_country AS delivery_for_whole_country_36,
  t0.show_message_for_customer AS show_message_for_customer_37,
  t0.message_for_customer AS message_for_customer_38,
  t0.warn_suppliers_about_this_customer_payments AS warn_suppliers_about_this_customer_payments_39,
  t0.avoid_user_for_create_new_inquiries AS avoid_user_for_create_new_inquiries_40,
  t0.show_stats_for_supplier AS show_stats_for_supplier_41,
  t0.supplier_card AS supplier_card_42,
  t0.supplier_card_short AS supplier_card_short_43,
  t0.supplier_card_active AS supplier_card_active_44,
  t0.show_won_offers_total_value AS show_won_offers_total_value_45,
  t0.show_ordered_parts_stats AS show_ordered_parts_stats_46,
  t0.regulations_accepted AS regulations_accepted_47,
  t0.created_at AS created_at_48,
  t0.updated_at AS updated_at_49,
  t0.active AS active_50,
  t0.created_by_id AS created_by_id_51,
  t0.updated_by_id AS updated_by_id_52
FROM
  customer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.nip AS nip_3, t0.username AS username_4, t0.password AS password_5, t0.phone_number AS phone_number_6, t0.last_inquiry_date AS last_inquiry_date_7, t0.last_offer_date AS last_offer_date_8, t0.is_recipient AS is_recipient_9, t0.is_supplier AS is_supplier_10, t0.roles AS roles_11, t0.salt AS salt_12, t0.register_key AS register_key_13, t0.reset_password_key AS reset_password_key_14, t0.zip_code AS zip_code_15, t0.city AS city_16, t0.street AS street_17, t0.property_number AS property_number_18, t0.apartment_number AS apartment_number_19, t0.show_other_offers AS show_other_offers_20, t0.dont_show_company_name_other_offers AS dont_show_company_name_other_offers_21, t0.igp AS igp_22, t0.can_choose_suppliers AS can_choose_suppliers_23, t0.can_see_supplier_data AS can_see_supplier_data_24, t0.show_other_offers_before_purchase AS show_other_offers_before_purchase_25, t0.show_only_retail_price_and_delivery_date AS show_only_retail_price_and_delivery_date_26, t0.notifications_offer_notification AS notifications_offer_notification_27, t0.notifications_offer_mail AS notifications_offer_mail_28, t0.notifications_inquiry_notification AS notifications_inquiry_notification_29, t0.notifications_inquiry_mail AS notifications_inquiry_mail_30, t0.notifications_invoice_notification AS notifications_invoice_notification_31, t0.notifications_invoice_mail AS notifications_invoice_mail_32, t0.can_delete_private_messages AS can_delete_private_messages_33, t0.can_see_other_suppliers_of_his_makes AS can_see_other_suppliers_of_his_makes_34, t0.can_get_notifications_about_better_offer AS can_get_notifications_about_better_offer_35, t0.delivery_for_whole_country AS delivery_for_whole_country_36, t0.show_message_for_customer AS show_message_for_customer_37, t0.message_for_customer AS message_for_customer_38, t0.warn_suppliers_about_this_customer_payments AS warn_suppliers_about_this_customer_payments_39, t0.avoid_user_for_create_new_inquiries AS avoid_user_for_create_new_inquiries_40, t0.show_stats_for_supplier AS show_stats_for_supplier_41, t0.supplier_card AS supplier_card_42, t0.supplier_card_short AS supplier_card_short_43, t0.supplier_card_active AS supplier_card_active_44, t0.show_won_offers_total_value AS show_won_offers_total_value_45, t0.show_ordered_parts_stats AS show_ordered_parts_stats_46, t0.regulations_accepted AS regulations_accepted_47, t0.created_at AS created_at_48, t0.updated_at AS updated_at_49, t0.active AS active_50, t0.created_by_id AS created_by_id_51, t0.updated_by_id AS updated_by_id_52 FROM customer t0 WHERE t0.id = 685;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.phone_number AS phone_number_3,
  t0.default_person AS default_person_4,
  t0.active AS active_5,
  t0.customer_id AS customer_id_6
FROM
  contact_person t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.phone_number AS phone_number_3, t0.default_person AS default_person_4, t0.active AS active_5, t0.customer_id AS customer_id_6 FROM contact_person t0 WHERE t0.id = 323;

SELECT
  t0.id AS id_1,
  t0.zip_code AS zip_code_2,
  t0.city AS city_3,
  t0.street AS street_4,
  t0.property_number AS property_number_5,
  t0.apartment_number AS apartment_number_6,
  t0.default_address AS default_address_7,
  t0.customer_id AS customer_id_8
FROM
  customer_address t0
WHERE
  t0.customer_id = ?

SELECT t0.id AS id_1, t0.zip_code AS zip_code_2, t0.city AS city_3, t0.street AS street_4, t0.property_number AS property_number_5, t0.apartment_number AS apartment_number_6, t0.default_address AS default_address_7, t0.customer_id AS customer_id_8 FROM customer_address t0 WHERE t0.customer_id = 66;

SELECT
  i0_.id AS id_0,
  i0_.expiration_date AS expiration_date_1,
  i0_.status AS status_2,
  i0_.vin AS vin_3,
  i0_.model AS model_4,
  i0_.registration_number AS registration_number_5,
  i0_.notices AS notices_6,
  i0_.archived AS archived_7,
  i0_.file_upload_id AS file_upload_id_8,
  i0_.notices_fv AS notices_fv_9,
  i0_.parts_received_date AS parts_received_date_10,
  i0_.parts_issued_date AS parts_issued_date_11,
  i0_.is_parts_received AS is_parts_received_12,
  i0_.is_parts_issued AS is_parts_issued_13,
  i0_.buyer_status AS buyer_status_14,
  i0_.seller_status AS seller_status_15,
  i0_.created_at AS created_at_16,
  i0_.updated_at AS updated_at_17,
  i0_.active AS active_18,
  (
    SELECT
      COUNT(o1_.id) AS sclr_20
    FROM
      offer o1_
    WHERE
      o1_.inquiry_id = i0_.id
      AND o1_.chosen = ?
  ) AS sclr_19,
  (
    SELECT
      COUNT(p2_.id) AS sclr_22
    FROM
      private_message p2_
    WHERE
      p2_.inquiry_id = i0_.id
      AND p2_.read_at IS NULL
  ) AS sclr_21
FROM
  inquiry i0_
WHERE
  i0_.recipient_id = ?
  AND i0_.archived = ?
HAVING
  sclr_19 = 0
ORDER BY
  sclr_21 DESC,
  i0_.id DESC

SELECT i0_.id AS id_0, i0_.expiration_date AS expiration_date_1, i0_.status AS status_2, i0_.vin AS vin_3, i0_.model AS model_4, i0_.registration_number AS registration_number_5, i0_.notices AS notices_6, i0_.archived AS archived_7, i0_.file_upload_id AS file_upload_id_8, i0_.notices_fv AS notices_fv_9, i0_.parts_received_date AS parts_received_date_10, i0_.parts_issued_date AS parts_issued_date_11, i0_.is_parts_received AS is_parts_received_12, i0_.is_parts_issued AS is_parts_issued_13, i0_.buyer_status AS buyer_status_14, i0_.seller_status AS seller_status_15, i0_.created_at AS created_at_16, i0_.updated_at AS updated_at_17, i0_.active AS active_18, (SELECT COUNT(o1_.id) AS sclr_20 FROM offer o1_ WHERE o1_.inquiry_id = i0_.id AND o1_.chosen = 1) AS sclr_19, (SELECT COUNT(p2_.id) AS sclr_22 FROM private_message p2_ WHERE p2_.inquiry_id = i0_.id AND p2_.read_at IS NULL) AS sclr_21 FROM inquiry i0_ WHERE i0_.recipient_id = 685 AND i0_.archived = 0 HAVING sclr_19 = 0 ORDER BY sclr_21 DESC, i0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.active AS active_5,
  t0.created_by_id AS created_by_id_6,
  t0.updated_by_id AS updated_by_id_7
FROM
  make t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.active AS active_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7 FROM make t0 WHERE t0.id = 18;

SELECT
  p0_.id AS id_0,
  o1_.id AS id_1,
  i2_.id AS id_2,
  p0_.created_at AS created_at_3
FROM
  private_message p0_
  LEFT JOIN notification n3_ ON (p0_.id = n3_.content_id)
  LEFT JOIN offer o1_ ON (n3_.entity_id = o1_.id)
  LEFT JOIN inquiry i2_ ON (o1_.inquiry_id = i2_.id)
WHERE
  n3_.read_at IS NULL
  AND p0_.read_at IS NULL
  AND n3_.entity_type = ?
  AND n3_.is_read = ?
  AND n3_.recipient_id = ?

SELECT p0_.id AS id_0, o1_.id AS id_1, i2_.id AS id_2, p0_.created_at AS created_at_3 FROM private_message p0_ LEFT JOIN notification n3_ ON (p0_.id = n3_.content_id) LEFT JOIN offer o1_ ON (n3_.entity_id = o1_.id) LEFT JOIN inquiry i2_ ON (o1_.inquiry_id = i2_.id) WHERE n3_.read_at IS NULL AND p0_.read_at IS NULL AND n3_.entity_type = 'offer' AND n3_.is_read = 0 AND n3_.recipient_id = 685;

SELECT
  i0_.id AS id_0,
  i0_.expiration_date AS expiration_date_1,
  i0_.status AS status_2,
  i0_.vin AS vin_3,
  i0_.model AS model_4,
  i0_.registration_number AS registration_number_5,
  i0_.notices AS notices_6,
  i0_.archived AS archived_7,
  i0_.file_upload_id AS file_upload_id_8,
  i0_.notices_fv AS notices_fv_9,
  i0_.parts_received_date AS parts_received_date_10,
  i0_.parts_issued_date AS parts_issued_date_11,
  i0_.is_parts_received AS is_parts_received_12,
  i0_.is_parts_issued AS is_parts_issued_13,
  i0_.buyer_status AS buyer_status_14,
  i0_.seller_status AS seller_status_15,
  i0_.created_at AS created_at_16,
  i0_.updated_at AS updated_at_17,
  i0_.active AS active_18,
  i0_.recipient_id AS recipient_id_19,
  i0_.invoice_address_id AS invoice_address_id_20,
  i0_.vin_photo_id AS vin_photo_id_21,
  i0_.estimate_file_id AS estimate_file_id_22,
  i0_.make_id AS make_id_23,
  i0_.customer_address_id AS customer_address_id_24,
  i0_.contact_person_id AS contact_person_id_25,
  i0_.created_by_id AS created_by_id_26,
  i0_.updated_by_id AS updated_by_id_27
FROM
  inquiry i0_
WHERE
  i0_.expiration_date < ?
  AND i0_.recipient_id = ?
  AND DATE_ADD(
    i0_.expiration_date, INTERVAL 30 DAY
  ) >= ?
  AND i0_.archived = ?
ORDER BY
  i0_.id DESC

SELECT i0_.id AS id_0, i0_.expiration_date AS expiration_date_1, i0_.status AS status_2, i0_.vin AS vin_3, i0_.model AS model_4, i0_.registration_number AS registration_number_5, i0_.notices AS notices_6, i0_.archived AS archived_7, i0_.file_upload_id AS file_upload_id_8, i0_.notices_fv AS notices_fv_9, i0_.parts_received_date AS parts_received_date_10, i0_.parts_issued_date AS parts_issued_date_11, i0_.is_parts_received AS is_parts_received_12, i0_.is_parts_issued AS is_parts_issued_13, i0_.buyer_status AS buyer_status_14, i0_.seller_status AS seller_status_15, i0_.created_at AS created_at_16, i0_.updated_at AS updated_at_17, i0_.active AS active_18, i0_.recipient_id AS recipient_id_19, i0_.invoice_address_id AS invoice_address_id_20, i0_.vin_photo_id AS vin_photo_id_21, i0_.estimate_file_id AS estimate_file_id_22, i0_.make_id AS make_id_23, i0_.customer_address_id AS customer_address_id_24, i0_.contact_person_id AS contact_person_id_25, i0_.created_by_id AS created_by_id_26, i0_.updated_by_id AS updated_by_id_27 FROM inquiry i0_ WHERE i0_.expiration_date < '2026-03-30 11:16:27' AND i0_.recipient_id = 685 AND DATE_ADD(i0_.expiration_date, INTERVAL 30 DAY) >= '2026-03-30 11:16:27' AND i0_.archived = 0 ORDER BY i0_.id DESC;

SELECT
  i0_.id AS id_0,
  i0_.expiration_date AS expiration_date_1,
  i0_.status AS status_2,
  i0_.vin AS vin_3,
  i0_.model AS model_4,
  i0_.registration_number AS registration_number_5,
  i0_.notices AS notices_6,
  i0_.archived AS archived_7,
  i0_.file_upload_id AS file_upload_id_8,
  i0_.notices_fv AS notices_fv_9,
  i0_.parts_received_date AS parts_received_date_10,
  i0_.parts_issued_date AS parts_issued_date_11,
  i0_.is_parts_received AS is_parts_received_12,
  i0_.is_parts_issued AS is_parts_issued_13,
  i0_.buyer_status AS buyer_status_14,
  i0_.seller_status AS seller_status_15,
  i0_.created_at AS created_at_16,
  i0_.updated_at AS updated_at_17,
  i0_.active AS active_18,
  (
    SELECT
      COUNT(o1_.id) AS sclr_20
    FROM
      offer o1_
    WHERE
      o1_.inquiry_id = i0_.id
      AND o1_.chosen = ?
  ) AS sclr_19,
  (
    SELECT
      COUNT(p2_.id) AS sclr_22
    FROM
      private_message p2_
    WHERE
      p2_.inquiry_id = i0_.id
      AND p2_.read_at IS NULL
  ) AS sclr_21,
  i0_.recipient_id AS recipient_id_23,
  i0_.invoice_address_id AS invoice_address_id_24,
  i0_.vin_photo_id AS vin_photo_id_25,
  i0_.estimate_file_id AS estimate_file_id_26,
  i0_.make_id AS make_id_27,
  i0_.customer_address_id AS customer_address_id_28,
  i0_.contact_person_id AS contact_person_id_29,
  i0_.created_by_id AS created_by_id_30,
  i0_.updated_by_id AS updated_by_id_31
FROM
  inquiry i0_
WHERE
  i0_.recipient_id = ?
  AND i0_.archived = ?
HAVING
  sclr_19 = 0
ORDER BY
  sclr_21 DESC,
  i0_.id DESC
LIMIT
  50

SELECT i0_.id AS id_0, i0_.expiration_date AS expiration_date_1, i0_.status AS status_2, i0_.vin AS vin_3, i0_.model AS model_4, i0_.registration_number AS registration_number_5, i0_.notices AS notices_6, i0_.archived AS archived_7, i0_.file_upload_id AS file_upload_id_8, i0_.notices_fv AS notices_fv_9, i0_.parts_received_date AS parts_received_date_10, i0_.parts_issued_date AS parts_issued_date_11, i0_.is_parts_received AS is_parts_received_12, i0_.is_parts_issued AS is_parts_issued_13, i0_.buyer_status AS buyer_status_14, i0_.seller_status AS seller_status_15, i0_.created_at AS created_at_16, i0_.updated_at AS updated_at_17, i0_.active AS active_18, (SELECT COUNT(o1_.id) AS sclr_20 FROM offer o1_ WHERE o1_.inquiry_id = i0_.id AND o1_.chosen = 1) AS sclr_19, (SELECT COUNT(p2_.id) AS sclr_22 FROM private_message p2_ WHERE p2_.inquiry_id = i0_.id AND p2_.read_at IS NULL) AS sclr_21, i0_.recipient_id AS recipient_id_23, i0_.invoice_address_id AS invoice_address_id_24, i0_.vin_photo_id AS vin_photo_id_25, i0_.estimate_file_id AS estimate_file_id_26, i0_.make_id AS make_id_27, i0_.customer_address_id AS customer_address_id_28, i0_.contact_person_id AS contact_person_id_29, i0_.created_by_id AS created_by_id_30, i0_.updated_by_id AS updated_by_id_31 FROM inquiry i0_ WHERE i0_.recipient_id = 685 AND i0_.archived = 0 HAVING sclr_19 = 0 ORDER BY sclr_21 DESC, i0_.id DESC LIMIT 50;

SELECT
  i0_.id AS id_0,
  i0_.expiration_date AS expiration_date_1,
  i0_.status AS status_2,
  i0_.vin AS vin_3,
  i0_.model AS model_4,
  i0_.registration_number AS registration_number_5,
  i0_.notices AS notices_6,
  i0_.archived AS archived_7,
  i0_.file_upload_id AS file_upload_id_8,
  i0_.notices_fv AS notices_fv_9,
  i0_.parts_received_date AS parts_received_date_10,
  i0_.parts_issued_date AS parts_issued_date_11,
  i0_.is_parts_received AS is_parts_received_12,
  i0_.is_parts_issued AS is_parts_issued_13,
  i0_.buyer_status AS buyer_status_14,
  i0_.seller_status AS seller_status_15,
  i0_.created_at AS created_at_16,
  i0_.updated_at AS updated_at_17,
  i0_.active AS active_18,
  i0_.recipient_id AS recipient_id_19,
  i0_.invoice_address_id AS invoice_address_id_20,
  i0_.vin_photo_id AS vin_photo_id_21,
  i0_.estimate_file_id AS estimate_file_id_22,
  i0_.make_id AS make_id_23,
  i0_.customer_address_id AS customer_address_id_24,
  i0_.contact_person_id AS contact_person_id_25,
  i0_.created_by_id AS created_by_id_26,
  i0_.updated_by_id AS updated_by_id_27
FROM
  inquiry i0_
  LEFT JOIN offer o1_ ON (o1_.inquiry_id = i0_.id)
WHERE
  o1_.chosen = ?
  AND i0_.recipient_id = ?
  AND i0_.archived = ?
ORDER BY
  i0_.id DESC
LIMIT
  50

SELECT i0_.id AS id_0, i0_.expiration_date AS expiration_date_1, i0_.status AS status_2, i0_.vin AS vin_3, i0_.model AS model_4, i0_.registration_number AS registration_number_5, i0_.notices AS notices_6, i0_.archived AS archived_7, i0_.file_upload_id AS file_upload_id_8, i0_.notices_fv AS notices_fv_9, i0_.parts_received_date AS parts_received_date_10, i0_.parts_issued_date AS parts_issued_date_11, i0_.is_parts_received AS is_parts_received_12, i0_.is_parts_issued AS is_parts_issued_13, i0_.buyer_status AS buyer_status_14, i0_.seller_status AS seller_status_15, i0_.created_at AS created_at_16, i0_.updated_at AS updated_at_17, i0_.active AS active_18, i0_.recipient_id AS recipient_id_19, i0_.invoice_address_id AS invoice_address_id_20, i0_.vin_photo_id AS vin_photo_id_21, i0_.estimate_file_id AS estimate_file_id_22, i0_.make_id AS make_id_23, i0_.customer_address_id AS customer_address_id_24, i0_.contact_person_id AS contact_person_id_25, i0_.created_by_id AS created_by_id_26, i0_.updated_by_id AS updated_by_id_27 FROM inquiry i0_ LEFT JOIN offer o1_ ON (o1_.inquiry_id = i0_.id) WHERE o1_.chosen = 1 AND i0_.recipient_id = 685 AND i0_.archived = 0 ORDER BY i0_.id DESC LIMIT 50;

SELECT
  i0_.id AS id_0
FROM
  inquiry i0_
  LEFT JOIN offer o1_ ON (o1_.inquiry_id = i0_.id)
WHERE
  o1_.chosen = ?
  AND i0_.recipient_id = ?
  AND i0_.archived = ?
ORDER BY
  i0_.id DESC

SELECT i0_.id AS id_0 FROM inquiry i0_ LEFT JOIN offer o1_ ON (o1_.inquiry_id = i0_.id) WHERE o1_.chosen = 1 AND i0_.recipient_id = 685 AND i0_.archived = 0 ORDER BY i0_.id DESC;

SELECT
  p0_.id AS id_0,
  o1_.id AS id_1,
  i2_.id AS id_2,
  p0_.created_at AS created_at_3
FROM
  private_message p0_
  LEFT JOIN notification n3_ ON (p0_.id = n3_.content_id)
  LEFT JOIN offer o1_ ON (p0_.offer_id = o1_.id)
  LEFT JOIN inquiry i2_ ON (p0_.inquiry_id = i2_.id)
WHERE
  n3_.read_at IS NULL
  AND p0_.read_at IS NULL
  AND n3_.is_read = ?
  AND n3_.recipient_id = ?

SELECT p0_.id AS id_0, o1_.id AS id_1, i2_.id AS id_2, p0_.created_at AS created_at_3 FROM private_message p0_ LEFT JOIN notification n3_ ON (p0_.id = n3_.content_id) LEFT JOIN offer o1_ ON (p0_.offer_id = o1_.id) LEFT JOIN inquiry i2_ ON (p0_.inquiry_id = i2_.id) WHERE n3_.read_at IS NULL AND p0_.read_at IS NULL AND n3_.is_read = 0 AND n3_.recipient_id = 685;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  private_message p0_
WHERE
  p0_.recipient_id = ?
  AND p0_.read_at IS NULL
ORDER BY
  p0_.created_at DESC

SELECT COUNT(p0_.id) AS sclr_0 FROM private_message p0_ WHERE p0_.recipient_id = 685 AND p0_.read_at IS NULL ORDER BY p0_.created_at DESC;

SELECT
  i0_.id AS id_0,
  i0_.expiration_date AS expiration_date_1,
  i0_.status AS status_2,
  i0_.vin AS vin_3,
  i0_.model AS model_4,
  i0_.registration_number AS registration_number_5,
  i0_.notices AS notices_6,
  i0_.archived AS archived_7,
  i0_.file_upload_id AS file_upload_id_8,
  i0_.notices_fv AS notices_fv_9,
  i0_.parts_received_date AS parts_received_date_10,
  i0_.parts_issued_date AS parts_issued_date_11,
  i0_.is_parts_received AS is_parts_received_12,
  i0_.is_parts_issued AS is_parts_issued_13,
  i0_.buyer_status AS buyer_status_14,
  i0_.seller_status AS seller_status_15,
  i0_.created_at AS created_at_16,
  i0_.updated_at AS updated_at_17,
  i0_.active AS active_18,
  o1_.id AS id_19,
  (
    SELECT
      COUNT(o2_.id) AS sclr_21
    FROM
      offer o2_
    WHERE
      o2_.inquiry_id = i0_.id
      AND o2_.supplier_id = ?
  ) AS sclr_20
FROM
  inquiry i0_
  LEFT JOIN offer o1_ ON (o1_.inquiry_id = i0_.id)
  LEFT JOIN inquiry_supplier i3_ ON i0_.id = i3_.inquiry_id
WHERE
  i0_.expiration_date >= ?
  AND i3_.customer_id IN (685)
  AND i0_.recipient_id <> ?
  AND i0_.archived = ?
  AND (
    i0_.make_id IN (NULL)
    OR i3_.customer_id IN (685)
  )
HAVING
  sclr_20 = 0
ORDER BY
  i0_.id DESC