Symfony Profiler

SELECT
  t0.clef AS clef_1,
  t0.valeur AS valeur_2
FROM
  app_config t0
WHERE
  t0.clef = ?

SELECT t0.clef AS clef_1, t0.valeur AS valeur_2 FROM app_config t0 WHERE t0.clef = 'maintenance_mode';

SELECT
  t0.id AS id_1,
  t0.type_tiers AS type_tiers_2,
  t0.enseigne_prospect AS enseigne_prospect_3,
  t0.nom AS nom_4,
  t0.prenom AS prenom_5,
  t0.email AS email_6,
  t0.phone AS phone_7,
  t0.created_at AS created_at_8,
  t0.status AS status_9,
  t0.score AS score_10,
  t0.pipeline_status AS pipeline_status_11,
  AsBinary(t0.location) AS location_12,
  t0.latitude AS latitude_13,
  t0.longitude AS longitude_14,
  t0.adresse_prospect AS adresse_prospect_15,
  t0.code_enseigne AS code_enseigne_16,
  t0.code_agent AS code_agent_17,
  t0.ifu_prospect AS ifu_prospect_18,
  t0.civilite_prospect AS civilite_prospect_19,
  t0.agent_nom AS agent_nom_20,
  t0.agent_prenom AS agent_prenom_21,
  t0.agent_photo AS agent_photo_22,
  t0.tva_assuj AS tva_assuj_23,
  t0.code_prospect AS code_prospect_24,
  t0.barcode AS barcode_25,
  t0.agent_uuid AS agent_uuid_26,
  t0.enseigne_id AS enseigne_id_27,
  t0.campaign_id AS campaign_id_28
FROM
  prospections t0
WHERE
  t0.id = ?
  AND (
    (t0.code_enseigne = 'YLWE')
  )

SELECT t0.id AS id_1, t0.type_tiers AS type_tiers_2, t0.enseigne_prospect AS enseigne_prospect_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.email AS email_6, t0.phone AS phone_7, t0.created_at AS created_at_8, t0.status AS status_9, t0.score AS score_10, t0.pipeline_status AS pipeline_status_11, AsBinary(t0.location) AS location_12, t0.latitude AS latitude_13, t0.longitude AS longitude_14, t0.adresse_prospect AS adresse_prospect_15, t0.code_enseigne AS code_enseigne_16, t0.code_agent AS code_agent_17, t0.ifu_prospect AS ifu_prospect_18, t0.civilite_prospect AS civilite_prospect_19, t0.agent_nom AS agent_nom_20, t0.agent_prenom AS agent_prenom_21, t0.agent_photo AS agent_photo_22, t0.tva_assuj AS tva_assuj_23, t0.code_prospect AS code_prospect_24, t0.barcode AS barcode_25, t0.agent_uuid AS agent_uuid_26, t0.enseigne_id AS enseigne_id_27, t0.campaign_id AS campaign_id_28 FROM prospections t0 WHERE t0.id = '668bd0fe-b6bd-4880-8d3e-8c7ffbfddd13' AND ((t0.code_enseigne = 'YLWE'));

SELECT
  t0.uuid AS uuid_1,
  t0.email AS email_2,
  t0.prenom AS prenom_3,
  t0.nom AS nom_4,
  t0.telephone AS telephone_5,
  t0.ifu AS ifu_6,
  t0.photo AS photo_7,
  t0.roles AS roles_8,
  t0.position_updated_at AS position_updated_at_9,
  t0.type_compte AS type_compte_10,
  t0.created_at AS created_at_11,
  t0.last_login_at AS last_login_at_12,
  t0.bpay_account AS bpay_account_13,
  t0.business_pay_account AS business_pay_account_14,
  t0.care_concept_account AS care_concept_account_15,
  t0.cashline_account AS cashline_account_16,
  t0.current_lat AS current_lat_17,
  t0.current_lon AS current_lon_18,
  t19.id AS id_20,
  t19.numero_carte AS numero_carte_21,
  t19.points_actuels AS points_actuels_22,
  t19.points_totaux AS points_totaux_23,
  t19.created_at AS created_at_24,
  t19.user_uuid AS user_uuid_25
FROM
  users t0
  LEFT JOIN fidelity_card t19 ON t19.user_uuid = t0.uuid
WHERE
  t0.uuid = ?

SELECT t0.uuid AS uuid_1, t0.email AS email_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.telephone AS telephone_5, t0.ifu AS ifu_6, t0.photo AS photo_7, t0.roles AS roles_8, t0.position_updated_at AS position_updated_at_9, t0.type_compte AS type_compte_10, t0.created_at AS created_at_11, t0.last_login_at AS last_login_at_12, t0.bpay_account AS bpay_account_13, t0.business_pay_account AS business_pay_account_14, t0.care_concept_account AS care_concept_account_15, t0.cashline_account AS cashline_account_16, t0.current_lat AS current_lat_17, t0.current_lon AS current_lon_18, t19.id AS id_20, t19.numero_carte AS numero_carte_21, t19.points_actuels AS points_actuels_22, t19.points_totaux AS points_totaux_23, t19.created_at AS created_at_24, t19.user_uuid AS user_uuid_25 FROM users t0 LEFT JOIN fidelity_card t19 ON t19.user_uuid = t0.uuid WHERE t0.uuid = '759d4938-4a3a-4c94-b244-28d1bf506b0f';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.start_date AS start_date_4,
  t0.end_date AS end_date_5,
  t0.status AS status_6,
  t0.is_active AS is_active_7,
  t0.season_id AS season_id_8,
  t0.enseigne_id AS enseigne_id_9,
  t0.owner_unit_id AS owner_unit_id_10
FROM
  campaign t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.status AS status_6, t0.is_active AS is_active_7, t0.season_id AS season_id_8, t0.enseigne_id AS enseigne_id_9, t0.owner_unit_id AS owner_unit_id_10 FROM campaign t0 WHERE t0.id = 1;

SELECT
  t0.uuid AS uuid_1,
  t0.email AS email_2,
  t0.prenom AS prenom_3,
  t0.nom AS nom_4,
  t0.telephone AS telephone_5,
  t0.ifu AS ifu_6,
  t0.photo AS photo_7,
  t0.roles AS roles_8,
  t0.position_updated_at AS position_updated_at_9,
  t0.type_compte AS type_compte_10,
  t0.created_at AS created_at_11,
  t0.last_login_at AS last_login_at_12,
  t0.bpay_account AS bpay_account_13,
  t0.business_pay_account AS business_pay_account_14,
  t0.care_concept_account AS care_concept_account_15,
  t0.cashline_account AS cashline_account_16,
  t0.current_lat AS current_lat_17,
  t0.current_lon AS current_lon_18,
  t19.id AS id_20,
  t19.numero_carte AS numero_carte_21,
  t19.points_actuels AS points_actuels_22,
  t19.points_totaux AS points_totaux_23,
  t19.created_at AS created_at_24,
  t19.user_uuid AS user_uuid_25
FROM
  users t0
  LEFT JOIN fidelity_card t19 ON t19.user_uuid = t0.uuid
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.uuid AS uuid_1, t0.email AS email_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.telephone AS telephone_5, t0.ifu AS ifu_6, t0.photo AS photo_7, t0.roles AS roles_8, t0.position_updated_at AS position_updated_at_9, t0.type_compte AS type_compte_10, t0.created_at AS created_at_11, t0.last_login_at AS last_login_at_12, t0.bpay_account AS bpay_account_13, t0.business_pay_account AS business_pay_account_14, t0.care_concept_account AS care_concept_account_15, t0.cashline_account AS cashline_account_16, t0.current_lat AS current_lat_17, t0.current_lon AS current_lon_18, t19.id AS id_20, t19.numero_carte AS numero_carte_21, t19.points_actuels AS points_actuels_22, t19.points_totaux AS points_totaux_23, t19.created_at AS created_at_24, t19.user_uuid AS user_uuid_25 FROM users t0 LEFT JOIN fidelity_card t19 ON t19.user_uuid = t0.uuid WHERE t0.email = 'gbenagnonagbannon@gmail.com' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.started_at AS started_at_3,
  t0.completed_at AS completed_at_4,
  t0.score AS score_5,
  t0.answers AS answers_6,
  t0.campaign_id AS campaign_id_7,
  t0.prospection_id AS prospection_id_8
FROM
  marketing_campaign_prospection t0
WHERE
  t0.prospection_id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.started_at AS started_at_3, t0.completed_at AS completed_at_4, t0.score AS score_5, t0.answers AS answers_6, t0.campaign_id AS campaign_id_7, t0.prospection_id AS prospection_id_8 FROM marketing_campaign_prospection t0 WHERE t0.prospection_id = '668bd0fe-b6bd-4880-8d3e-8c7ffbfddd13';

SELECT
  t0.id AS id_1,
  t0.code_enseigne AS code_enseigne_2,
  t0.label AS label_3,
  t0.type AS type_4,
  t0.position AS position_5,
  t0.required AS required_6,
  t0.condition_question_id AS condition_question_id_7,
  t0.condition_value AS condition_value_8,
  t0.order_index AS order_index_9,
  t0.questionnaire_id AS questionnaire_id_10
FROM
  discovery_question t0
WHERE
  t0.questionnaire_id = ?
  AND (
    (t0.code_enseigne = 'YLWE')
  )

SELECT t0.id AS id_1, t0.code_enseigne AS code_enseigne_2, t0.label AS label_3, t0.type AS type_4, t0.position AS position_5, t0.required AS required_6, t0.condition_question_id AS condition_question_id_7, t0.condition_value AS condition_value_8, t0.order_index AS order_index_9, t0.questionnaire_id AS questionnaire_id_10 FROM discovery_question t0 WHERE t0.questionnaire_id = 2 AND ((t0.code_enseigne = 'YLWE'));

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.campaign_id AS campaign_id_3,
  t0.questionnaire_id AS questionnaire_id_4
FROM
  campaign_questionnaire t0
WHERE
  t0.campaign_id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.campaign_id AS campaign_id_3, t0.questionnaire_id AS questionnaire_id_4 FROM campaign_questionnaire t0 WHERE t0.campaign_id = 1;

SELECT
  t0.id AS id_1,
  t0.code_enseigne AS code_enseigne_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.active AS active_5,
  t0.created_at AS created_at_6,
  t0.enseigne_id AS enseigne_id_7
FROM
  discovery_questionnaire t0
WHERE
  t0.id = ?
  AND (
    (t0.code_enseigne = 'YLWE')
  )

SELECT t0.id AS id_1, t0.code_enseigne AS code_enseigne_2, t0.name AS name_3, t0.description AS description_4, t0.active AS active_5, t0.created_at AS created_at_6, t0.enseigne_id AS enseigne_id_7 FROM discovery_questionnaire t0 WHERE t0.id = 2 AND ((t0.code_enseigne = 'YLWE'));