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
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.description AS description_2,
  c0_.start_date AS start_date_3,
  c0_.end_date AS end_date_4,
  c0_.status AS status_5,
  c0_.is_active AS is_active_6,
  c0_.season_id AS season_id_7,
  c0_.enseigne_id AS enseigne_id_8,
  c0_.owner_unit_id AS owner_unit_id_9
FROM
  campaign c0_
  INNER JOIN campaign_unit_assignment c1_ ON c0_.id = c1_.campaign_id
  INNER JOIN hr_organizational_unit h2_ ON c1_.organizational_unit_id = h2_.id
WHERE
  c0_.is_active = ?
  AND h2_.id IN (?, ?)
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.start_date AS start_date_3, c0_.end_date AS end_date_4, c0_.status AS status_5, c0_.is_active AS is_active_6, c0_.season_id AS season_id_7, c0_.enseigne_id AS enseigne_id_8, c0_.owner_unit_id AS owner_unit_id_9 FROM campaign c0_ INNER JOIN campaign_unit_assignment c1_ ON c0_.id = c1_.campaign_id INNER JOIN hr_organizational_unit h2_ ON c1_.organizational_unit_id = h2_.id WHERE c0_.is_active = 1 AND h2_.id IN ('68c22437-8759-46c4-aeb2-fa442a8abc94', 'b459629f-638d-4217-a046-d1f78114a2b4') ORDER BY c0_.name ASC;

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 = 'b313b862-4af2-4626-b7fb-3b9b6708b7aa';

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.selected_pack_id AS selected_pack_id_26,
  t0.estimated_revenue AS estimated_revenue_27,
  t0.note_publique AS note_publique_28,
  t0.note_privee AS note_privee_29,
  t0.is_converted AS is_converted_30,
  t0.conversion_pack_id AS conversion_pack_id_31,
  t0.converted_at AS converted_at_32,
  t0.agent_uuid AS agent_uuid_33,
  t0.enseigne_id AS enseigne_id_34,
  t0.campaign_id AS campaign_id_35,
  t0.temperature_id AS temperature_id_36,
  t0.converted_by_id AS converted_by_id_37
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.selected_pack_id AS selected_pack_id_26, t0.estimated_revenue AS estimated_revenue_27, t0.note_publique AS note_publique_28, t0.note_privee AS note_privee_29, t0.is_converted AS is_converted_30, t0.conversion_pack_id AS conversion_pack_id_31, t0.converted_at AS converted_at_32, t0.agent_uuid AS agent_uuid_33, t0.enseigne_id AS enseigne_id_34, t0.campaign_id AS campaign_id_35, t0.temperature_id AS temperature_id_36, t0.converted_by_id AS converted_by_id_37 FROM prospections t0 WHERE t0.id = '82fa76b7-1f72-4701-b85c-b2cc1a0c30ce' 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.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 = 'f_alassanemalim1@n2a.online' 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_26
FROM
  users t0
  LEFT JOIN fidelity_card t19 ON t19.user_uuid = t0.uuid
WHERE
  t0.uuid = ?
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_26 FROM users t0 LEFT JOIN fidelity_card t19 ON t19.user_uuid = t0.uuid WHERE t0.uuid = 'b313b862-4af2-4626-b7fb-3b9b6708b7aa' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.weight AS weight_3,
  t0.color AS color_4,
  t0.description AS description_5
FROM
  temperature t0
ORDER BY
  t0.weight ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.weight AS weight_3, t0.color AS color_4, t0.description AS description_5 FROM temperature t0 ORDER BY t0.weight ASC;

SELECT
  t0.id AS id_1,
  t0.role_in_unit AS role_in_unit_2,
  t0.is_manager AS is_manager_3,
  t0.start_date AS start_date_4,
  t0.end_date AS end_date_5,
  t0.assigned_at AS assigned_at_6,
  t0.user_uuid AS user_uuid_7,
  t0.unit_id AS unit_id_8
FROM
  hr_user_unit t0
WHERE
  t0.user_uuid = ?

SELECT t0.id AS id_1, t0.role_in_unit AS role_in_unit_2, t0.is_manager AS is_manager_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.assigned_at AS assigned_at_6, t0.user_uuid AS user_uuid_7, t0.unit_id AS unit_id_8 FROM hr_user_unit t0 WHERE t0.user_uuid = 'b313b862-4af2-4626-b7fb-3b9b6708b7aa';