Symfony Profiler

[
  "route" => "legacy_controller"
  "route_parameters" => [
    "_route" => "legacy_controller"
    "_controller" => "App\Controller\LegacyBridgeController::legacy_controller"
    "route" => "idev_order_form/idev_order_form/ws_get_order_form_count"
  ]
  "request_uri" => "https://crm.home-arnrso.com/idev_order_form/idev_order_form/ws_get_order_form_count"
  "method" => "POST"
]

[
  "firewall_name" => "main"
  "authenticators" => 3
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "adrien-crm-sql"
    "port" => 3306
    "user" => "crm"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "approcrm_prod"
    "serverVersion" => "8.4.4"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "195"
    2 => "2"
    3 => "pending"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2157
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2157}
    3 => Doctrine\DBAL\ParameterType {#2157}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "195"
    2 => "2"
    3 => "pending"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2157
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2157}
    3 => Doctrine\DBAL\ParameterType {#2157}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 0
    2 => 0
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2102
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#2102}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 0
    2 => 0
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2102
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#2102}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "195"
    2 => "2"
    3 => "pending"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2157
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2157}
    3 => Doctrine\DBAL\ParameterType {#2157}
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "195"
    2 => "2"
    3 => "pending"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#2157
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#2157}
    3 => Doctrine\DBAL\ParameterType {#2157}
  ]
]