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.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_resume_at';

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 = 'b3e2a1b1-0824-4ce3-a1f1-12f7ae0a81dd';

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 = 'r_dossou@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 = 'b3e2a1b1-0824-4ce3-a1f1-12f7ae0a81dd' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom AS nom_3,
  t0.libelle AS libelle_4,
  t0.main_db_host AS main_db_host_5,
  t0.main_db_name AS main_db_name_6,
  t0.main_db_user AS main_db_user_7,
  t0.main_db_pass AS main_db_pass_8,
  t0.base_url AS base_url_9,
  t0.api_key AS api_key_10,
  t0.dgi_token AS dgi_token_11,
  t12.id AS id_13,
  t12.daily_prospection_target AS daily_prospection_target_14,
  t12.weekly_prospection_target AS weekly_prospection_target_15,
  t12.monthly_prospection_target AS monthly_prospection_target_16,
  t12.daily_conversion_rate AS daily_conversion_rate_17,
  t12.weekly_conversion_rate AS weekly_conversion_rate_18,
  t12.monthly_conversion_rate AS monthly_conversion_rate_19,
  t12.enseigne_id AS enseigne_id_20
FROM
  enseignes t0
  LEFT JOIN enseigne_settings t12 ON t12.enseigne_id = t0.id
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.libelle AS libelle_4, t0.main_db_host AS main_db_host_5, t0.main_db_name AS main_db_name_6, t0.main_db_user AS main_db_user_7, t0.main_db_pass AS main_db_pass_8, t0.base_url AS base_url_9, t0.api_key AS api_key_10, t0.dgi_token AS dgi_token_11, t12.id AS id_13, t12.daily_prospection_target AS daily_prospection_target_14, t12.weekly_prospection_target AS weekly_prospection_target_15, t12.monthly_prospection_target AS monthly_prospection_target_16, t12.daily_conversion_rate AS daily_conversion_rate_17, t12.weekly_conversion_rate AS weekly_conversion_rate_18, t12.monthly_conversion_rate AS monthly_conversion_rate_19, t12.enseigne_id AS enseigne_id_20 FROM enseignes t0 LEFT JOIN enseigne_settings t12 ON t12.enseigne_id = t0.id WHERE t0.code = 'YLWE' LIMIT 1;

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 = '2';

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
WHERE
  t0.id = ?

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 WHERE t0.id = '2';

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO prospections (
  id, type_tiers, enseigne_prospect,
  nom, prenom, email, phone, created_at,
  status, score, pipeline_status, location,
  latitude, longitude, adresse_prospect,
  code_enseigne, code_agent, ifu_prospect,
  civilite_prospect, agent_nom, agent_prenom,
  agent_photo, tva_assuj, code_prospect,
  barcode, selected_pack_id, estimated_revenue,
  note_publique, note_privee, is_converted,
  conversion_pack_id, converted_at,
  agent_uuid, enseigne_id, campaign_id,
  temperature_id, converted_by_id
)
VALUES
  (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    GeomFromText(?),
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )

INSERT INTO prospections (id, type_tiers, enseigne_prospect, nom, prenom, email, phone, created_at, status, score, pipeline_status, location, latitude, longitude, adresse_prospect, code_enseigne, code_agent, ifu_prospect, civilite_prospect, agent_nom, agent_prenom, agent_photo, tva_assuj, code_prospect, barcode, selected_pack_id, estimated_revenue, note_publique, note_privee, is_converted, conversion_pack_id, converted_at, agent_uuid, enseigne_id, campaign_id, temperature_id, converted_by_id) VALUES ('9949f88d-508e-4c52-b283-7db405108d85', 'Particulier', NULL, 'daCRUZ', 'Armel', '22967295322@myn2a.online', '+2290167295322', '2026-04-28 18:00:58', 'nouveau', 30, 'nouveau', GeomFromText(NULL), NULL, NULL, 'Cotonou ', 'YLWE', 'b3e2a1b1-0824-4ce3-a1f1-12f7ae0a81dd', '', 'MR', 'DOSSOU', 'Ruth', 'https://business-n2a.myn2a.online/uploads/photos/profil/Ruth-DOSSOUSnapchat-1548873417-69f0c33fad0d8.jpg', NULL, 'YLWE-PRT-280426-A08A79A8', 'YLWE-PRT-280426-A08A79A8', 1, NULL, 'Le prospect est très occupé. 
Il m\'a dit qu\'il n\'a pas du tout le temps en ce moment ', 'Lui laisser un peu de temps', 0, NULL, NULL, 'b3e2a1b1-0824-4ce3-a1f1-12f7ae0a81dd', 46, 2, 2, NULL);

"COMMIT"

"COMMIT";