Symfony Profiler

SELECT
  COUNT(DISTINCT i0_.uid) AS sclr_0,
  COUNT(DISTINCT i1_.uid) AS sclr_1
FROM
  idev_order_form i0_
  INNER JOIN idev_order_form_vehicle i1_ ON (i0_.uid = i1_.id_order_form)
WHERE
  i0_.id_contact IN (?)
  AND i0_.id_site IN (?)
  AND i0_.status IN (?)
  AND i0_.deleted = 0
  AND i0_.hidden = 0
  AND i1_.deleted = 0
  AND i1_.hidden = 0

SELECT COUNT(DISTINCT i0_.uid) AS sclr_0, COUNT(DISTINCT i1_.uid) AS sclr_1 FROM idev_order_form i0_ INNER JOIN idev_order_form_vehicle i1_ ON (i0_.uid = i1_.id_order_form) WHERE i0_.id_contact IN ('195') AND i0_.id_site IN ('2') AND i0_.status IN ('pending') AND i0_.deleted = 0 AND i0_.hidden = 0 AND i1_.deleted = 0 AND i1_.hidden = 0;

SELECT
  DISTINCT uid_0
FROM
  (
    SELECT
      DISTINCT uid_0,
      crdate_1
    FROM
      (
        SELECT
          i0_.uid AS uid_0,
          i0_.crdate AS crdate_1,
          i0_.moddate AS moddate_2,
          i0_.hidden AS hidden_3,
          i0_.deleted AS deleted_4,
          i0_.status AS status_5,
          i0_.comment AS comment_6,
          i0_.delivery_date AS delivery_date_7,
          i0_.payment_condition AS payment_condition_8,
          i0_.payment_mode AS payment_mode_9,
          i0_.expiry_date AS expiry_date_10,
          i0_.id_kepler AS id_kepler_11,
          i0_.order_form_delivery_location_label AS order_form_delivery_location_label_12,
          i0_.payment_condition_label AS payment_condition_label_13,
          i0_.payment_mode_label AS payment_mode_label_14,
          i0_.total_without_tax AS total_without_tax_15,
          i0_.tax_zone AS tax_zone_16,
          i0_.tax_rate_standard AS tax_rate_standard_17,
          i0_.tax_rate_margin AS tax_rate_margin_18,
          i0_.total_with_tax AS total_with_tax_19,
          i0_.tax_summary AS tax_summary_20,
          i0_.site_data AS site_data_21,
          i0_.contact_data AS contact_data_22,
          i0_.user_data AS user_data_23,
          i0_.rib_user_data AS rib_user_data_24,
          i0_.notes AS notes_25,
          i0_.contact_address AS contact_address_26,
          i0_.alerted AS alerted_27,
          i0_.non_matching_kepler_price AS non_matching_kepler_price_28,
          i0_.second_payment_mode AS second_payment_mode_29,
          i0_.second_payment_mode_label AS second_payment_mode_label_30,
          i0_.second_payment_amount AS second_payment_amount_31,
          i0_.second_payment_condition AS second_payment_condition_32,
          i0_.second_payment_condition_label AS second_payment_condition_label_33,
          i0_.first_available_discounted_bill_date AS first_available_discounted_bill_date_34,
          i0_.second_payment_expiry_date AS second_payment_expiry_date_35,
          i0_.delivery_warning AS delivery_warning_36,
          i0_.contact_city AS contact_city_37,
          i0_.imported_from_kepler AS imported_from_kepler_38,
          i0_.unknown_delivery_date AS unknown_delivery_date_39,
          i0_.seen_date AS seen_date_40,
          i0_.accepted_date AS accepted_date_41,
          i0_.from_click_and_buy AS from_click_and_buy_42
        FROM
          idev_order_form i0_
        WHERE
          i0_.deleted = 0
          AND i0_.hidden = 0
          AND i0_.id_contact IN (?)
          AND i0_.id_site IN (?)
          AND i0_.status IN (?)
      ) dctrn_result_inner
    ORDER BY
      crdate_1 DESC
  ) dctrn_result
LIMIT
  50

SELECT DISTINCT uid_0 FROM (SELECT DISTINCT uid_0, crdate_1 FROM (SELECT i0_.uid AS uid_0, i0_.crdate AS crdate_1, i0_.moddate AS moddate_2, i0_.hidden AS hidden_3, i0_.deleted AS deleted_4, i0_.status AS status_5, i0_.comment AS comment_6, i0_.delivery_date AS delivery_date_7, i0_.payment_condition AS payment_condition_8, i0_.payment_mode AS payment_mode_9, i0_.expiry_date AS expiry_date_10, i0_.id_kepler AS id_kepler_11, i0_.order_form_delivery_location_label AS order_form_delivery_location_label_12, i0_.payment_condition_label AS payment_condition_label_13, i0_.payment_mode_label AS payment_mode_label_14, i0_.total_without_tax AS total_without_tax_15, i0_.tax_zone AS tax_zone_16, i0_.tax_rate_standard AS tax_rate_standard_17, i0_.tax_rate_margin AS tax_rate_margin_18, i0_.total_with_tax AS total_with_tax_19, i0_.tax_summary AS tax_summary_20, i0_.site_data AS site_data_21, i0_.contact_data AS contact_data_22, i0_.user_data AS user_data_23, i0_.rib_user_data AS rib_user_data_24, i0_.notes AS notes_25, i0_.contact_address AS contact_address_26, i0_.alerted AS alerted_27, i0_.non_matching_kepler_price AS non_matching_kepler_price_28, i0_.second_payment_mode AS second_payment_mode_29, i0_.second_payment_mode_label AS second_payment_mode_label_30, i0_.second_payment_amount AS second_payment_amount_31, i0_.second_payment_condition AS second_payment_condition_32, i0_.second_payment_condition_label AS second_payment_condition_label_33, i0_.first_available_discounted_bill_date AS first_available_discounted_bill_date_34, i0_.second_payment_expiry_date AS second_payment_expiry_date_35, i0_.delivery_warning AS delivery_warning_36, i0_.contact_city AS contact_city_37, i0_.imported_from_kepler AS imported_from_kepler_38, i0_.unknown_delivery_date AS unknown_delivery_date_39, i0_.seen_date AS seen_date_40, i0_.accepted_date AS accepted_date_41, i0_.from_click_and_buy AS from_click_and_buy_42 FROM idev_order_form i0_ WHERE i0_.deleted = 0 AND i0_.hidden = 0 AND i0_.id_contact IN ('195') AND i0_.id_site IN ('2') AND i0_.status IN ('pending')) dctrn_result_inner ORDER BY crdate_1 DESC) dctrn_result LIMIT 50;

SELECT
  t0.uid AS uid_1,
  t0.crdate AS crdate_2,
  t0.moddate AS moddate_3,
  t0.hidden AS hidden_4,
  t0.deleted AS deleted_5,
  t0.id_vehicle AS id_vehicle_6,
  t0.hub_vehicle AS hub_vehicle_7,
  t0.price AS price_8,
  t0.price_without_tax AS price_without_tax_9,
  t0.tax_zone AS tax_zone_10,
  t0.tax_rate AS tax_rate_11,
  t0.tax_label AS tax_label_12,
  t0.tax_value AS tax_value_13,
  t0.origin_label AS origin_label_14,
  t0.provider_id_contact AS provider_id_contact_15,
  t0.reference AS reference_16,
  t0.vin AS vin_17,
  t0.park_id_establishment AS park_id_establishment_18,
  t0.kepler_supplier AS kepler_supplier_19,
  t0.hub_brand_uid AS hub_brand_uid_20,
  t0.hub_version_uid AS hub_version_uid_21,
  t0.hub_provider AS hub_provider_22,
  t0.hub_merchant_price_reduced AS hub_merchant_price_reduced_23,
  t0.hub_merchant_price AS hub_merchant_price_24,
  t0.hub_attribute_batch_price AS hub_attribute_batch_price_25,
  t0.hub_attribute_purchase_price AS hub_attribute_purchase_price_26,
  t0.hub_attribute_purchase_price_without_tax AS hub_attribute_purchase_price_without_tax_27,
  t0.hub_attribute_purchase_tax AS hub_attribute_purchase_tax_28,
  t0.sum_price_without_tax_hub_attribute_service_purchase_list AS sum_price_without_tax_hub_attribute_service_purchase_list_29,
  t0.non_matching_kepler_fees AS non_matching_kepler_fees_30,
  t0.hub_brand_label AS hub_brand_label_31,
  t0.hub_version_label AS hub_version_label_32,
  t0.bill_date AS bill_date_33,
  t0.bill_details AS bill_details_34,
  t0.cancelled AS cancelled_35,
  t0.hub_attribute_vehicle_purchase_buyer AS hub_attribute_vehicle_purchase_buyer_36,
  t0.id_order_form AS id_order_form_37
FROM
  idev_order_form_vehicle t0
WHERE
  t0.deleted = ?
  AND t0.hidden = ?
  AND 1 = 0

SELECT t0.uid AS uid_1, t0.crdate AS crdate_2, t0.moddate AS moddate_3, t0.hidden AS hidden_4, t0.deleted AS deleted_5, t0.id_vehicle AS id_vehicle_6, t0.hub_vehicle AS hub_vehicle_7, t0.price AS price_8, t0.price_without_tax AS price_without_tax_9, t0.tax_zone AS tax_zone_10, t0.tax_rate AS tax_rate_11, t0.tax_label AS tax_label_12, t0.tax_value AS tax_value_13, t0.origin_label AS origin_label_14, t0.provider_id_contact AS provider_id_contact_15, t0.reference AS reference_16, t0.vin AS vin_17, t0.park_id_establishment AS park_id_establishment_18, t0.kepler_supplier AS kepler_supplier_19, t0.hub_brand_uid AS hub_brand_uid_20, t0.hub_version_uid AS hub_version_uid_21, t0.hub_provider AS hub_provider_22, t0.hub_merchant_price_reduced AS hub_merchant_price_reduced_23, t0.hub_merchant_price AS hub_merchant_price_24, t0.hub_attribute_batch_price AS hub_attribute_batch_price_25, t0.hub_attribute_purchase_price AS hub_attribute_purchase_price_26, t0.hub_attribute_purchase_price_without_tax AS hub_attribute_purchase_price_without_tax_27, t0.hub_attribute_purchase_tax AS hub_attribute_purchase_tax_28, t0.sum_price_without_tax_hub_attribute_service_purchase_list AS sum_price_without_tax_hub_attribute_service_purchase_list_29, t0.non_matching_kepler_fees AS non_matching_kepler_fees_30, t0.hub_brand_label AS hub_brand_label_31, t0.hub_version_label AS hub_version_label_32, t0.bill_date AS bill_date_33, t0.bill_details AS bill_details_34, t0.cancelled AS cancelled_35, t0.hub_attribute_vehicle_purchase_buyer AS hub_attribute_vehicle_purchase_buyer_36, t0.id_order_form AS id_order_form_37 FROM idev_order_form_vehicle t0 WHERE t0.deleted = 0 AND t0.hidden = 0 AND 1=0;

SELECT
  t0.uid AS uid_1,
  t0.crdate AS crdate_2,
  t0.moddate AS moddate_3,
  t0.hidden AS hidden_4,
  t0.deleted AS deleted_5,
  t0.debit AS debit_6,
  t0.debit_enddate AS debit_enddate_7,
  t0.debit_term AS debit_term_8,
  t0.debit_startdate AS debit_startdate_9,
  t0.debit_taken_into_account_startdate AS debit_taken_into_account_startdate_10,
  t0.debit_taken_into_account_enddate AS debit_taken_into_account_enddate_11,
  t0.number_of_reminders_sent_to_client AS number_of_reminders_sent_to_client_12,
  t0.number_of_reminders_sent_to_accountancy AS number_of_reminders_sent_to_accountancy_13,
  t0.id_traite_sage AS id_traite_sage_14,
  t0.id_universign AS id_universign_15,
  t0.status AS status_16,
  t0.file_path AS file_path_17,
  t0.id_marketing AS id_marketing_18,
  t0.id_order_form AS id_order_form_19
FROM
  idev_marketing_pro_financial_discounted_bill t0
WHERE
  t0.deleted = ?
  AND t0.hidden = ?
  AND 1 = 0

SELECT t0.uid AS uid_1, t0.crdate AS crdate_2, t0.moddate AS moddate_3, t0.hidden AS hidden_4, t0.deleted AS deleted_5, t0.debit AS debit_6, t0.debit_enddate AS debit_enddate_7, t0.debit_term AS debit_term_8, t0.debit_startdate AS debit_startdate_9, t0.debit_taken_into_account_startdate AS debit_taken_into_account_startdate_10, t0.debit_taken_into_account_enddate AS debit_taken_into_account_enddate_11, t0.number_of_reminders_sent_to_client AS number_of_reminders_sent_to_client_12, t0.number_of_reminders_sent_to_accountancy AS number_of_reminders_sent_to_accountancy_13, t0.id_traite_sage AS id_traite_sage_14, t0.id_universign AS id_universign_15, t0.status AS status_16, t0.file_path AS file_path_17, t0.id_marketing AS id_marketing_18, t0.id_order_form AS id_order_form_19 FROM idev_marketing_pro_financial_discounted_bill t0 WHERE t0.deleted = 0 AND t0.hidden = 0 AND 1=0;

SELECT
  DISTINCT uid_0
FROM
  (
    SELECT
      DISTINCT uid_0,
      crdate_1
    FROM
      (
        SELECT
          i0_.uid AS uid_0,
          i0_.crdate AS crdate_1,
          i0_.moddate AS moddate_2,
          i0_.hidden AS hidden_3,
          i0_.deleted AS deleted_4,
          i0_.status AS status_5,
          i0_.comment AS comment_6,
          i0_.delivery_date AS delivery_date_7,
          i0_.payment_condition AS payment_condition_8,
          i0_.payment_mode AS payment_mode_9,
          i0_.expiry_date AS expiry_date_10,
          i0_.id_kepler AS id_kepler_11,
          i0_.order_form_delivery_location_label AS order_form_delivery_location_label_12,
          i0_.payment_condition_label AS payment_condition_label_13,
          i0_.payment_mode_label AS payment_mode_label_14,
          i0_.total_without_tax AS total_without_tax_15,
          i0_.tax_zone AS tax_zone_16,
          i0_.tax_rate_standard AS tax_rate_standard_17,
          i0_.tax_rate_margin AS tax_rate_margin_18,
          i0_.total_with_tax AS total_with_tax_19,
          i0_.tax_summary AS tax_summary_20,
          i0_.site_data AS site_data_21,
          i0_.contact_data AS contact_data_22,
          i0_.user_data AS user_data_23,
          i0_.rib_user_data AS rib_user_data_24,
          i0_.notes AS notes_25,
          i0_.contact_address AS contact_address_26,
          i0_.alerted AS alerted_27,
          i0_.non_matching_kepler_price AS non_matching_kepler_price_28,
          i0_.second_payment_mode AS second_payment_mode_29,
          i0_.second_payment_mode_label AS second_payment_mode_label_30,
          i0_.second_payment_amount AS second_payment_amount_31,
          i0_.second_payment_condition AS second_payment_condition_32,
          i0_.second_payment_condition_label AS second_payment_condition_label_33,
          i0_.first_available_discounted_bill_date AS first_available_discounted_bill_date_34,
          i0_.second_payment_expiry_date AS second_payment_expiry_date_35,
          i0_.delivery_warning AS delivery_warning_36,
          i0_.contact_city AS contact_city_37,
          i0_.imported_from_kepler AS imported_from_kepler_38,
          i0_.unknown_delivery_date AS unknown_delivery_date_39,
          i0_.seen_date AS seen_date_40,
          i0_.accepted_date AS accepted_date_41,
          i0_.from_click_and_buy AS from_click_and_buy_42
        FROM
          idev_order_form i0_
        WHERE
          i0_.deleted = 0
          AND i0_.hidden = 0
          AND i0_.id_contact IN (?)
          AND i0_.id_site IN (?)
          AND i0_.status IN (?)
      ) dctrn_result_inner
    ORDER BY
      crdate_1 DESC
  ) dctrn_result
LIMIT
  50

SELECT DISTINCT uid_0 FROM (SELECT DISTINCT uid_0, crdate_1 FROM (SELECT i0_.uid AS uid_0, i0_.crdate AS crdate_1, i0_.moddate AS moddate_2, i0_.hidden AS hidden_3, i0_.deleted AS deleted_4, i0_.status AS status_5, i0_.comment AS comment_6, i0_.delivery_date AS delivery_date_7, i0_.payment_condition AS payment_condition_8, i0_.payment_mode AS payment_mode_9, i0_.expiry_date AS expiry_date_10, i0_.id_kepler AS id_kepler_11, i0_.order_form_delivery_location_label AS order_form_delivery_location_label_12, i0_.payment_condition_label AS payment_condition_label_13, i0_.payment_mode_label AS payment_mode_label_14, i0_.total_without_tax AS total_without_tax_15, i0_.tax_zone AS tax_zone_16, i0_.tax_rate_standard AS tax_rate_standard_17, i0_.tax_rate_margin AS tax_rate_margin_18, i0_.total_with_tax AS total_with_tax_19, i0_.tax_summary AS tax_summary_20, i0_.site_data AS site_data_21, i0_.contact_data AS contact_data_22, i0_.user_data AS user_data_23, i0_.rib_user_data AS rib_user_data_24, i0_.notes AS notes_25, i0_.contact_address AS contact_address_26, i0_.alerted AS alerted_27, i0_.non_matching_kepler_price AS non_matching_kepler_price_28, i0_.second_payment_mode AS second_payment_mode_29, i0_.second_payment_mode_label AS second_payment_mode_label_30, i0_.second_payment_amount AS second_payment_amount_31, i0_.second_payment_condition AS second_payment_condition_32, i0_.second_payment_condition_label AS second_payment_condition_label_33, i0_.first_available_discounted_bill_date AS first_available_discounted_bill_date_34, i0_.second_payment_expiry_date AS second_payment_expiry_date_35, i0_.delivery_warning AS delivery_warning_36, i0_.contact_city AS contact_city_37, i0_.imported_from_kepler AS imported_from_kepler_38, i0_.unknown_delivery_date AS unknown_delivery_date_39, i0_.seen_date AS seen_date_40, i0_.accepted_date AS accepted_date_41, i0_.from_click_and_buy AS from_click_and_buy_42 FROM idev_order_form i0_ WHERE i0_.deleted = 0 AND i0_.hidden = 0 AND i0_.id_contact IN ('195') AND i0_.id_site IN ('2') AND i0_.status IN ('pending')) dctrn_result_inner ORDER BY crdate_1 DESC) dctrn_result LIMIT 50;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT uid_0
    FROM
      (
        SELECT
          i0_.uid AS uid_0,
          i0_.crdate AS crdate_1,
          i0_.moddate AS moddate_2,
          i0_.hidden AS hidden_3,
          i0_.deleted AS deleted_4,
          i0_.status AS status_5,
          i0_.comment AS comment_6,
          i0_.delivery_date AS delivery_date_7,
          i0_.payment_condition AS payment_condition_8,
          i0_.payment_mode AS payment_mode_9,
          i0_.expiry_date AS expiry_date_10,
          i0_.id_kepler AS id_kepler_11,
          i0_.order_form_delivery_location_label AS order_form_delivery_location_label_12,
          i0_.payment_condition_label AS payment_condition_label_13,
          i0_.payment_mode_label AS payment_mode_label_14,
          i0_.total_without_tax AS total_without_tax_15,
          i0_.tax_zone AS tax_zone_16,
          i0_.tax_rate_standard AS tax_rate_standard_17,
          i0_.tax_rate_margin AS tax_rate_margin_18,
          i0_.total_with_tax AS total_with_tax_19,
          i0_.tax_summary AS tax_summary_20,
          i0_.site_data AS site_data_21,
          i0_.contact_data AS contact_data_22,
          i0_.user_data AS user_data_23,
          i0_.rib_user_data AS rib_user_data_24,
          i0_.notes AS notes_25,
          i0_.contact_address AS contact_address_26,
          i0_.alerted AS alerted_27,
          i0_.non_matching_kepler_price AS non_matching_kepler_price_28,
          i0_.second_payment_mode AS second_payment_mode_29,
          i0_.second_payment_mode_label AS second_payment_mode_label_30,
          i0_.second_payment_amount AS second_payment_amount_31,
          i0_.second_payment_condition AS second_payment_condition_32,
          i0_.second_payment_condition_label AS second_payment_condition_label_33,
          i0_.first_available_discounted_bill_date AS first_available_discounted_bill_date_34,
          i0_.second_payment_expiry_date AS second_payment_expiry_date_35,
          i0_.delivery_warning AS delivery_warning_36,
          i0_.contact_city AS contact_city_37,
          i0_.imported_from_kepler AS imported_from_kepler_38,
          i0_.unknown_delivery_date AS unknown_delivery_date_39,
          i0_.seen_date AS seen_date_40,
          i0_.accepted_date AS accepted_date_41,
          i0_.from_click_and_buy AS from_click_and_buy_42
        FROM
          idev_order_form i0_
        WHERE
          i0_.deleted = 0
          AND i0_.hidden = 0
          AND i0_.id_contact IN (?)
          AND i0_.id_site IN (?)
          AND i0_.status IN (?)
        ORDER BY
          i0_.crdate DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT uid_0 FROM (SELECT i0_.uid AS uid_0, i0_.crdate AS crdate_1, i0_.moddate AS moddate_2, i0_.hidden AS hidden_3, i0_.deleted AS deleted_4, i0_.status AS status_5, i0_.comment AS comment_6, i0_.delivery_date AS delivery_date_7, i0_.payment_condition AS payment_condition_8, i0_.payment_mode AS payment_mode_9, i0_.expiry_date AS expiry_date_10, i0_.id_kepler AS id_kepler_11, i0_.order_form_delivery_location_label AS order_form_delivery_location_label_12, i0_.payment_condition_label AS payment_condition_label_13, i0_.payment_mode_label AS payment_mode_label_14, i0_.total_without_tax AS total_without_tax_15, i0_.tax_zone AS tax_zone_16, i0_.tax_rate_standard AS tax_rate_standard_17, i0_.tax_rate_margin AS tax_rate_margin_18, i0_.total_with_tax AS total_with_tax_19, i0_.tax_summary AS tax_summary_20, i0_.site_data AS site_data_21, i0_.contact_data AS contact_data_22, i0_.user_data AS user_data_23, i0_.rib_user_data AS rib_user_data_24, i0_.notes AS notes_25, i0_.contact_address AS contact_address_26, i0_.alerted AS alerted_27, i0_.non_matching_kepler_price AS non_matching_kepler_price_28, i0_.second_payment_mode AS second_payment_mode_29, i0_.second_payment_mode_label AS second_payment_mode_label_30, i0_.second_payment_amount AS second_payment_amount_31, i0_.second_payment_condition AS second_payment_condition_32, i0_.second_payment_condition_label AS second_payment_condition_label_33, i0_.first_available_discounted_bill_date AS first_available_discounted_bill_date_34, i0_.second_payment_expiry_date AS second_payment_expiry_date_35, i0_.delivery_warning AS delivery_warning_36, i0_.contact_city AS contact_city_37, i0_.imported_from_kepler AS imported_from_kepler_38, i0_.unknown_delivery_date AS unknown_delivery_date_39, i0_.seen_date AS seen_date_40, i0_.accepted_date AS accepted_date_41, i0_.from_click_and_buy AS from_click_and_buy_42 FROM idev_order_form i0_ WHERE i0_.deleted = 0 AND i0_.hidden = 0 AND i0_.id_contact IN ('195') AND i0_.id_site IN ('2') AND i0_.status IN ('pending') ORDER BY i0_.crdate DESC) dctrn_result) dctrn_table;