Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.value AS value_2,
  s0_.description AS description_3
FROM
  system_setting s0_
WHERE
  s0_.name = ?

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.description AS description_3 FROM system_setting s0_ WHERE s0_.name = 'api.gocad.username';

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.value AS value_2,
  s0_.description AS description_3
FROM
  system_setting s0_
WHERE
  s0_.name = ?

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.value AS value_2, s0_.description AS description_3 FROM system_setting s0_ WHERE s0_.name = 'api.gocad.password';

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.enabled AS enabled_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.email_token AS email_token_8,
  t0.is_password_set AS is_password_set_9,
  t0.email_token_date AS email_token_date_10,
  t11.id AS id_12,
  t11.firstname AS firstname_13,
  t11.lastname AS lastname_14,
  t11.email AS email_15,
  t11.phone AS phone_16,
  t11.user_id AS user_id_17,
  t11.function_id AS function_id_18,
  t11.address_id AS address_id_19,
  t0.default_btob_territory_id AS default_btob_territory_id_20,
  t0.default_btoc_territory_id AS default_btoc_territory_id_21,
  t0.login_message_id AS login_message_id_22
FROM
  `user` t0
  LEFT JOIN profile t11 ON t11.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.enabled AS enabled_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.email_token AS email_token_8, t0.is_password_set AS is_password_set_9, t0.email_token_date AS email_token_date_10, t11.id AS id_12, t11.firstname AS firstname_13, t11.lastname AS lastname_14, t11.email AS email_15, t11.phone AS phone_16, t11.user_id AS user_id_17, t11.function_id AS function_id_18, t11.address_id AS address_id_19, t0.default_btob_territory_id AS default_btob_territory_id_20, t0.default_btoc_territory_id AS default_btoc_territory_id_21, t0.login_message_id AS login_message_id_22 FROM `user` t0 LEFT JOIN profile t11 ON t11.user_id = t0.id WHERE t0.id = 0x019C9C272DCF7A88B9E817D88910B5FA;

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  `order` o0_

SELECT COUNT(o0_.id) AS sclr_0 FROM `order` o0_;

SELECT
  DISTINCT COUNT(DISTINCT o0_.id) AS sclr_0
FROM
  `order` o0_
  LEFT JOIN sale_ref s1_ ON o0_.sale_ref_id = s1_.id
  LEFT JOIN `user` u2_ ON o0_.created_by_id = u2_.id
  LEFT JOIN profile p3_ ON u2_.id = p3_.user_id
  LEFT JOIN network n4_ ON s1_.network_id = n4_.id
  LEFT JOIN referential r5_ ON o0_.type_id = r5_.id
  AND r5_.discr IN ('refType')
  LEFT JOIN referential r6_ ON o0_.status_id = r6_.id
  AND r6_.discr IN ('refOrderStatus')
  LEFT JOIN target t7_ ON o0_.target_id = t7_.id
  LEFT JOIN order_items o9_ ON o0_.id = o9_.order_id
  LEFT JOIN order_base_item o8_ ON o8_.id = o9_.item_id
  AND o8_.discr IN ('canal')
  LEFT JOIN referential r10_ ON o8_.canal_id = r10_.id
  AND r10_.discr IN ('refCanal')

SELECT DISTINCT COUNT(DISTINCT o0_.id) AS sclr_0 FROM `order` o0_ LEFT JOIN sale_ref s1_ ON o0_.sale_ref_id = s1_.id LEFT JOIN `user` u2_ ON o0_.created_by_id = u2_.id LEFT JOIN profile p3_ ON u2_.id = p3_.user_id LEFT JOIN network n4_ ON s1_.network_id = n4_.id LEFT JOIN referential r5_ ON o0_.type_id = r5_.id AND r5_.discr IN ('refType') LEFT JOIN referential r6_ ON o0_.status_id = r6_.id AND r6_.discr IN ('refOrderStatus') LEFT JOIN target t7_ ON o0_.target_id = t7_.id LEFT JOIN order_items o9_ ON o0_.id = o9_.order_id LEFT JOIN order_base_item o8_ ON o8_.id = o9_.item_id AND o8_.discr IN ('canal') LEFT JOIN referential r10_ ON o8_.canal_id = r10_.id AND r10_.discr IN ('refCanal');

SELECT
  DISTINCT o0_.id AS id_0,
  o0_.number AS number_1,
  o0_.name AS name_2,
  o0_.created_at AS created_at_3,
  o0_.updated_at AS updated_at_4,
  o0_.task_id AS task_id_5,
  o0_.data AS data_6,
  o0_.status_history AS status_history_7,
  o0_.admin_approved AS admin_approved_8,
  s1_.id AS id_9,
  s1_.code AS code_10,
  s1_.social_reason AS social_reason_11,
  s1_.commercial_name AS commercial_name_12,
  s1_.enabled AS enabled_13,
  s1_.created_at AS created_at_14,
  s1_.updated_at AS updated_at_15,
  s1_.subscribed AS subscribed_16,
  s1_.subscription AS subscription_17,
  s1_.license_siv AS license_siv_18,
  s1_.subscription_type AS subscription_type_19,
  s1_.phone AS phone_20,
  u2_.id AS id_21,
  u2_.username AS username_22,
  u2_.roles AS roles_23,
  u2_.password AS password_24,
  u2_.enabled AS enabled_25,
  u2_.created_at AS created_at_26,
  u2_.updated_at AS updated_at_27,
  u2_.email_token AS email_token_28,
  u2_.is_password_set AS is_password_set_29,
  u2_.email_token_date AS email_token_date_30,
  p3_.id AS id_31,
  p3_.firstname AS firstname_32,
  p3_.lastname AS lastname_33,
  p3_.email AS email_34,
  p3_.phone AS phone_35,
  n4_.id AS id_36,
  n4_.code AS code_37,
  n4_.name AS name_38,
  n4_.description AS description_39,
  n4_.enabled AS enabled_40,
  n4_.logo AS logo_41,
  n4_.gocad_id AS gocad_id_42,
  n4_.gocad_server_id AS gocad_server_id_43,
  n4_.db_sources AS db_sources_44,
  n4_.conditions_generales AS conditions_generales_45,
  n4_.devis_payment_mode AS devis_payment_mode_46,
  n4_.devis_legal_payment_mention AS devis_legal_payment_mention_47,
  n4_.devis_bottom_page AS devis_bottom_page_48,
  n4_.reduction AS reduction_49,
  n4_.devis_code AS devis_code_50,
  n4_.free_fiche AS free_fiche_51,
  r5_.id AS id_52,
  r5_.name AS name_53,
  r5_.enabled AS enabled_54,
  r6_.id AS id_55,
  r6_.name AS name_56,
  r6_.enabled AS enabled_57,
  t7_.id AS id_58,
  t7_.name AS name_59,
  t7_.description AS description_60,
  t7_.created_at AS created_at_61,
  t7_.data AS data_62,
  t7_.top_target AS top_target_63,
  o8_.id AS id_64,
  o8_.description AS description_65,
  o8_.amount AS amount_66,
  r9_.id AS id_67,
  r9_.name AS name_68,
  r9_.enabled AS enabled_69,
  o0_.type_id AS type_id_70,
  o0_.mode_id AS mode_id_71,
  o0_.created_by_id AS created_by_id_72,
  o0_.sale_ref_id AS sale_ref_id_73,
  o0_.status_id AS status_id_74,
  o0_.target_id AS target_id_75,
  s1_.network_id AS network_id_76,
  s1_.subscription_price_id AS subscription_price_id_77,
  s1_.alternative_billing_information_id AS alternative_billing_information_id_78,
  s1_.split_id AS split_id_79,
  s1_.type_id AS type_id_80,
  u2_.default_btob_territory_id AS default_btob_territory_id_81,
  u2_.default_btoc_territory_id AS default_btoc_territory_id_82,
  u2_.login_message_id AS login_message_id_83,
  p3_.user_id AS user_id_84,
  p3_.function_id AS function_id_85,
  p3_.address_id AS address_id_86,
  n4_.default_subscription_price_id AS default_subscription_price_id_87,
  n4_.type_id AS type_id_88,
  n4_.billing_information_id AS billing_information_id_89,
  n4_.subscription_price_id AS subscription_price_id_90,
  r5_.discr AS discr_91,
  r6_.discr AS discr_92,
  t7_.type_id AS type_id_93,
  t7_.created_by_id AS created_by_id_94,
  t7_.network_id AS network_id_95,
  o8_.discr AS discr_96,
  o8_.price_id AS price_id_97,
  o8_.canal_id AS canal_id_98,
  r9_.discr AS discr_99
FROM
  `order` o0_
  LEFT JOIN sale_ref s1_ ON o0_.sale_ref_id = s1_.id
  LEFT JOIN `user` u2_ ON o0_.created_by_id = u2_.id
  LEFT JOIN profile p3_ ON u2_.id = p3_.user_id
  LEFT JOIN network n4_ ON s1_.network_id = n4_.id
  LEFT JOIN referential r5_ ON o0_.type_id = r5_.id
  AND r5_.discr IN ('refType')
  LEFT JOIN referential r6_ ON o0_.status_id = r6_.id
  AND r6_.discr IN ('refOrderStatus')
  LEFT JOIN target t7_ ON o0_.target_id = t7_.id
  LEFT JOIN order_items o10_ ON o0_.id = o10_.order_id
  LEFT JOIN order_base_item o8_ ON o8_.id = o10_.item_id
  AND o8_.discr IN ('canal')
  LEFT JOIN referential r9_ ON o8_.canal_id = r9_.id
  AND r9_.discr IN ('refCanal')
ORDER BY
  o0_.created_at DESC
LIMIT
  10

SELECT DISTINCT o0_.id AS id_0, o0_.number AS number_1, o0_.name AS name_2, o0_.created_at AS created_at_3, o0_.updated_at AS updated_at_4, o0_.task_id AS task_id_5, o0_.data AS data_6, o0_.status_history AS status_history_7, o0_.admin_approved AS admin_approved_8, s1_.id AS id_9, s1_.code AS code_10, s1_.social_reason AS social_reason_11, s1_.commercial_name AS commercial_name_12, s1_.enabled AS enabled_13, s1_.created_at AS created_at_14, s1_.updated_at AS updated_at_15, s1_.subscribed AS subscribed_16, s1_.subscription AS subscription_17, s1_.license_siv AS license_siv_18, s1_.subscription_type AS subscription_type_19, s1_.phone AS phone_20, u2_.id AS id_21, u2_.username AS username_22, u2_.roles AS roles_23, u2_.password AS password_24, u2_.enabled AS enabled_25, u2_.created_at AS created_at_26, u2_.updated_at AS updated_at_27, u2_.email_token AS email_token_28, u2_.is_password_set AS is_password_set_29, u2_.email_token_date AS email_token_date_30, p3_.id AS id_31, p3_.firstname AS firstname_32, p3_.lastname AS lastname_33, p3_.email AS email_34, p3_.phone AS phone_35, n4_.id AS id_36, n4_.code AS code_37, n4_.name AS name_38, n4_.description AS description_39, n4_.enabled AS enabled_40, n4_.logo AS logo_41, n4_.gocad_id AS gocad_id_42, n4_.gocad_server_id AS gocad_server_id_43, n4_.db_sources AS db_sources_44, n4_.conditions_generales AS conditions_generales_45, n4_.devis_payment_mode AS devis_payment_mode_46, n4_.devis_legal_payment_mention AS devis_legal_payment_mention_47, n4_.devis_bottom_page AS devis_bottom_page_48, n4_.reduction AS reduction_49, n4_.devis_code AS devis_code_50, n4_.free_fiche AS free_fiche_51, r5_.id AS id_52, r5_.name AS name_53, r5_.enabled AS enabled_54, r6_.id AS id_55, r6_.name AS name_56, r6_.enabled AS enabled_57, t7_.id AS id_58, t7_.name AS name_59, t7_.description AS description_60, t7_.created_at AS created_at_61, t7_.data AS data_62, t7_.top_target AS top_target_63, o8_.id AS id_64, o8_.description AS description_65, o8_.amount AS amount_66, r9_.id AS id_67, r9_.name AS name_68, r9_.enabled AS enabled_69, o0_.type_id AS type_id_70, o0_.mode_id AS mode_id_71, o0_.created_by_id AS created_by_id_72, o0_.sale_ref_id AS sale_ref_id_73, o0_.status_id AS status_id_74, o0_.target_id AS target_id_75, s1_.network_id AS network_id_76, s1_.subscription_price_id AS subscription_price_id_77, s1_.alternative_billing_information_id AS alternative_billing_information_id_78, s1_.split_id AS split_id_79, s1_.type_id AS type_id_80, u2_.default_btob_territory_id AS default_btob_territory_id_81, u2_.default_btoc_territory_id AS default_btoc_territory_id_82, u2_.login_message_id AS login_message_id_83, p3_.user_id AS user_id_84, p3_.function_id AS function_id_85, p3_.address_id AS address_id_86, n4_.default_subscription_price_id AS default_subscription_price_id_87, n4_.type_id AS type_id_88, n4_.billing_information_id AS billing_information_id_89, n4_.subscription_price_id AS subscription_price_id_90, r5_.discr AS discr_91, r6_.discr AS discr_92, t7_.type_id AS type_id_93, t7_.created_by_id AS created_by_id_94, t7_.network_id AS network_id_95, o8_.discr AS discr_96, o8_.price_id AS price_id_97, o8_.canal_id AS canal_id_98, r9_.discr AS discr_99 FROM `order` o0_ LEFT JOIN sale_ref s1_ ON o0_.sale_ref_id = s1_.id LEFT JOIN `user` u2_ ON o0_.created_by_id = u2_.id LEFT JOIN profile p3_ ON u2_.id = p3_.user_id LEFT JOIN network n4_ ON s1_.network_id = n4_.id LEFT JOIN referential r5_ ON o0_.type_id = r5_.id AND r5_.discr IN ('refType') LEFT JOIN referential r6_ ON o0_.status_id = r6_.id AND r6_.discr IN ('refOrderStatus') LEFT JOIN target t7_ ON o0_.target_id = t7_.id LEFT JOIN order_items o10_ ON o0_.id = o10_.order_id LEFT JOIN order_base_item o8_ ON o8_.id = o10_.item_id AND o8_.discr IN ('canal') LEFT JOIN referential r9_ ON o8_.canal_id = r9_.id AND r9_.discr IN ('refCanal') ORDER BY o0_.created_at DESC LIMIT 10;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.social_reason AS social_reason_3,
  t0.enabled AS enabled_4,
  t0.iban AS iban_5,
  t0.bic AS bic_6,
  t0.bank_label AS bank_label_7,
  t0.sale_ref_id AS sale_ref_id_8,
  t0.type_id AS type_id_9,
  t0.address_id AS address_id_10
FROM
  billing_information t0
WHERE
  t0.sale_ref_id IN (?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.name AS name_2, t0.social_reason AS social_reason_3, t0.enabled AS enabled_4, t0.iban AS iban_5, t0.bic AS bic_6, t0.bank_label AS bank_label_7, t0.sale_ref_id AS sale_ref_id_8, t0.type_id AS type_id_9, t0.address_id AS address_id_10 FROM billing_information t0 WHERE t0.sale_ref_id IN (2578, 2417, 284, 772, 769);

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.amount AS amount_3,
  t0.price_id AS price_id_4,
  t0.discr,
  t0.canal_id AS canal_id_5
FROM
  order_base_item t0
  INNER JOIN order_fixedFees ON t0.id = order_fixedFees.item_id
WHERE
  order_fixedFees.order_id = ?
  AND t0.discr IN ('base', 'canal')

SELECT t0.id AS id_1, t0.description AS description_2, t0.amount AS amount_3, t0.price_id AS price_id_4, t0.discr, t0.canal_id AS canal_id_5 FROM order_base_item t0 INNER JOIN order_fixedFees ON t0.id = order_fixedFees.item_id WHERE order_fixedFees.order_id = 9969 AND t0.discr IN ('base', 'canal');

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.unit_ht AS unit_ht_3,
  t0.vat AS vat_4,
  t0.total_ht AS total_ht_5,
  t0.total_ttc AS total_ttc_6
FROM
  price t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.unit_ht AS unit_ht_3, t0.vat AS vat_4, t0.total_ht AS total_ht_5, t0.total_ttc AS total_ttc_6 FROM price t0 WHERE t0.id = 27545;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.unit_ht AS unit_ht_3,
  t0.vat AS vat_4,
  t0.total_ht AS total_ht_5,
  t0.total_ttc AS total_ttc_6
FROM
  price t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.unit_ht AS unit_ht_3, t0.vat AS vat_4, t0.total_ht AS total_ht_5, t0.total_ttc AS total_ttc_6 FROM price t0 WHERE t0.id = 27546;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.unit_ht AS unit_ht_3,
  t0.vat AS vat_4,
  t0.total_ht AS total_ht_5,
  t0.total_ttc AS total_ttc_6
FROM
  price t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.unit_ht AS unit_ht_3, t0.vat AS vat_4, t0.total_ht AS total_ht_5, t0.total_ttc AS total_ttc_6 FROM price t0 WHERE t0.id = 27547;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.unit_ht AS unit_ht_3,
  t0.vat AS vat_4,
  t0.total_ht AS total_ht_5,
  t0.total_ttc AS total_ttc_6
FROM
  price t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.unit_ht AS unit_ht_3, t0.vat AS vat_4, t0.total_ht AS total_ht_5, t0.total_ttc AS total_ttc_6 FROM price t0 WHERE t0.id = 27548;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.unit_ht AS unit_ht_3,
  t0.vat AS vat_4,
  t0.total_ht AS total_ht_5,
  t0.total_ttc AS total_ttc_6
FROM
  price t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.unit_ht AS unit_ht_3, t0.vat AS vat_4, t0.total_ht AS total_ht_5, t0.total_ttc AS total_ttc_6 FROM price t0 WHERE t0.id = 27549;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.unit_ht AS unit_ht_3,
  t0.vat AS vat_4,
  t0.total_ht AS total_ht_5,
  t0.total_ttc AS total_ttc_6
FROM
  price t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.unit_ht AS unit_ht_3, t0.vat AS vat_4, t0.total_ht AS total_ht_5, t0.total_ttc AS total_ttc_6 FROM price t0 WHERE t0.id = 27550;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.unit_ht AS unit_ht_3,
  t0.vat AS vat_4,
  t0.total_ht AS total_ht_5,
  t0.total_ttc AS total_ttc_6
FROM
  price t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.unit_ht AS unit_ht_3, t0.vat AS vat_4, t0.total_ht AS total_ht_5, t0.total_ttc AS total_ttc_6 FROM price t0 WHERE t0.id = 27551;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.unit_ht AS unit_ht_3,
  t0.vat AS vat_4,
  t0.total_ht AS total_ht_5,
  t0.total_ttc AS total_ttc_6
FROM
  price t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.unit_ht AS unit_ht_3, t0.vat AS vat_4, t0.total_ht AS total_ht_5, t0.total_ttc AS total_ttc_6 FROM price t0 WHERE t0.id = 27552;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.amount AS amount_3,
  t0.price_id AS price_id_4,
  t0.discr,
  t0.canal_id AS canal_id_5
FROM
  order_base_item t0
  INNER JOIN order_fixedFees ON t0.id = order_fixedFees.item_id
WHERE
  order_fixedFees.order_id = ?
  AND t0.discr IN ('base', 'canal')

SELECT t0.id AS id_1, t0.description AS description_2, t0.amount AS amount_3, t0.price_id AS price_id_4, t0.discr, t0.canal_id AS canal_id_5 FROM order_base_item t0 INNER JOIN order_fixedFees ON t0.id = order_fixedFees.item_id WHERE order_fixedFees.order_id = 9970 AND t0.discr IN ('base', 'canal');

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.unit_ht AS unit_ht_3,
  t0.vat AS vat_4,
  t0.total_ht AS total_ht_5,
  t0.total_ttc AS total_ttc_6
FROM
  price t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.unit_ht AS unit_ht_3, t0.vat AS vat_4, t0.total_ht AS total_ht_5, t0.total_ttc AS total_ttc_6 FROM price t0 WHERE t0.id = 27553;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.unit_ht AS unit_ht_3,
  t0.vat AS vat_4,
  t0.total_ht AS total_ht_5,
  t0.total_ttc AS total_ttc_6
FROM
  price t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.unit_ht AS unit_ht_3, t0.vat AS vat_4, t0.total_ht AS total_ht_5, t0.total_ttc AS total_ttc_6 FROM price t0 WHERE t0.id = 27554;