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.type_compte AS type_compte_9,
  t0.created_at AS created_at_10,
  t0.last_login_at AS last_login_at_11,
  t0.bpay_account AS bpay_account_12,
  t0.business_pay_account AS business_pay_account_13,
  t0.care_concept_account AS care_concept_account_14,
  t0.cashline_account AS cashline_account_15
FROM
  users t0
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.type_compte AS type_compte_9, t0.created_at AS created_at_10, t0.last_login_at AS last_login_at_11, t0.bpay_account AS bpay_account_12, t0.business_pay_account AS business_pay_account_13, t0.care_concept_account AS care_concept_account_14, t0.cashline_account AS cashline_account_15 FROM users t0 WHERE t0.uuid = '6a3d3a8b-05d5-45f4-a790-0eaa2ef0523d';

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.type_compte AS type_compte_9,
  t0.created_at AS created_at_10,
  t0.last_login_at AS last_login_at_11,
  t0.bpay_account AS bpay_account_12,
  t0.business_pay_account AS business_pay_account_13,
  t0.care_concept_account AS care_concept_account_14,
  t0.cashline_account AS cashline_account_15
FROM
  users t0
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.type_compte AS type_compte_9, t0.created_at AS created_at_10, t0.last_login_at AS last_login_at_11, t0.bpay_account AS bpay_account_12, t0.business_pay_account AS business_pay_account_13, t0.care_concept_account AS care_concept_account_14, t0.cashline_account AS cashline_account_15 FROM users t0 WHERE t0.email = 'superadmin@magmaerp.online' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.enseigne_id AS enseigne_id_2,
  t0.enseigne_nom AS enseigne_nom_3,
  t0.code_enseigne AS code_enseigne_4,
  t0.last_business_sync_at AS last_business_sync_at_5,
  t0.formule_nom AS formule_nom_6,
  t0.active AS active_7,
  t0.billing_mode AS billing_mode_8,
  t0.premium_users_limit AS premium_users_limit_9,
  t0.max_collaborateurs AS max_collaborateurs_10,
  t0.total_connexion_minutes AS total_connexion_minutes_11,
  t0.usage_billing_enabled AS usage_billing_enabled_12,
  t0.temporary_start_at AS temporary_start_at_13,
  t0.temporary_end_at AS temporary_end_at_14,
  t0.hours_purchased AS hours_purchased_15,
  t0.days_purchased AS days_purchased_16,
  t0.custom_price AS custom_price_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19,
  t0.subscribed_at AS subscribed_at_20,
  t0.last_renewal_at AS last_renewal_at_21,
  t0.next_renewal_at AS next_renewal_at_22,
  t0.auto_renew AS auto_renew_23,
  t0.renewal_attempts AS renewal_attempts_24,
  t0.grace_period_end_at AS grace_period_end_at_25,
  t0.suspended_at AS suspended_at_26,
  t0.suspension_reason AS suspension_reason_27,
  t0.cancelled_at AS cancelled_at_28,
  t0.enseigne_id AS enseigne_id_29,
  t0.formule_id AS formule_id_30,
  t0.billing_plan_id AS billing_plan_id_31
FROM
  formule_enseigne t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.enseigne_id AS enseigne_id_2, t0.enseigne_nom AS enseigne_nom_3, t0.code_enseigne AS code_enseigne_4, t0.last_business_sync_at AS last_business_sync_at_5, t0.formule_nom AS formule_nom_6, t0.active AS active_7, t0.billing_mode AS billing_mode_8, t0.premium_users_limit AS premium_users_limit_9, t0.max_collaborateurs AS max_collaborateurs_10, t0.total_connexion_minutes AS total_connexion_minutes_11, t0.usage_billing_enabled AS usage_billing_enabled_12, t0.temporary_start_at AS temporary_start_at_13, t0.temporary_end_at AS temporary_end_at_14, t0.hours_purchased AS hours_purchased_15, t0.days_purchased AS days_purchased_16, t0.custom_price AS custom_price_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.subscribed_at AS subscribed_at_20, t0.last_renewal_at AS last_renewal_at_21, t0.next_renewal_at AS next_renewal_at_22, t0.auto_renew AS auto_renew_23, t0.renewal_attempts AS renewal_attempts_24, t0.grace_period_end_at AS grace_period_end_at_25, t0.suspended_at AS suspended_at_26, t0.suspension_reason AS suspension_reason_27, t0.cancelled_at AS cancelled_at_28, t0.enseigne_id AS enseigne_id_29, t0.formule_id AS formule_id_30, t0.billing_plan_id AS billing_plan_id_31 FROM formule_enseigne t0 WHERE t0.id = 64;

SELECT
  b0_.id AS id_0,
  b0_.enseigne_id AS enseigne_id_1,
  b0_.enseigne_label AS enseigne_label_2,
  b0_.enseigne_code AS enseigne_code_3,
  b0_.user_uuid AS user_uuid_4,
  b0_.user_email AS user_email_5,
  b0_.user_full_name AS user_full_name_6,
  b0_.module_id AS module_id_7,
  b0_.module_label AS module_label_8,
  b0_.section_id AS section_id_9,
  b0_.section_label AS section_label_10,
  b0_.privilege_id AS privilege_id_11,
  b0_.privilege_label AS privilege_label_12,
  b0_.billing_type AS billing_type_13,
  b0_.unit_price AS unit_price_14,
  b0_.quantity AS quantity_15,
  b0_.total_price AS total_price_16,
  b0_.currency AS currency_17,
  b0_.billing_status AS billing_status_18,
  b0_.billing_date AS billing_date_19,
  b0_.route AS route_20,
  b0_.ip AS ip_21,
  b0_.context AS context_22,
  b0_.created_at AS created_at_23
FROM
  billing_usage b0_
WHERE
  b0_.enseigne_id = ?
  AND b0_.billing_date >= ?
  AND b0_.billing_date < ?
ORDER BY
  b0_.billing_date DESC

SELECT b0_.id AS id_0, b0_.enseigne_id AS enseigne_id_1, b0_.enseigne_label AS enseigne_label_2, b0_.enseigne_code AS enseigne_code_3, b0_.user_uuid AS user_uuid_4, b0_.user_email AS user_email_5, b0_.user_full_name AS user_full_name_6, b0_.module_id AS module_id_7, b0_.module_label AS module_label_8, b0_.section_id AS section_id_9, b0_.section_label AS section_label_10, b0_.privilege_id AS privilege_id_11, b0_.privilege_label AS privilege_label_12, b0_.billing_type AS billing_type_13, b0_.unit_price AS unit_price_14, b0_.quantity AS quantity_15, b0_.total_price AS total_price_16, b0_.currency AS currency_17, b0_.billing_status AS billing_status_18, b0_.billing_date AS billing_date_19, b0_.route AS route_20, b0_.ip AS ip_21, b0_.context AS context_22, b0_.created_at AS created_at_23 FROM billing_usage b0_ WHERE b0_.enseigne_id = 33 AND b0_.billing_date >= '2026-09-12' AND b0_.billing_date < '2026-09-13' ORDER BY b0_.billing_date DESC;

SELECT
  b0_.id AS id_0,
  b0_.enseigne_id AS enseigne_id_1,
  b0_.enseigne_label AS enseigne_label_2,
  b0_.enseigne_code AS enseigne_code_3,
  b0_.user_uuid AS user_uuid_4,
  b0_.user_email AS user_email_5,
  b0_.user_full_name AS user_full_name_6,
  b0_.module_id AS module_id_7,
  b0_.module_label AS module_label_8,
  b0_.section_id AS section_id_9,
  b0_.section_label AS section_label_10,
  b0_.privilege_id AS privilege_id_11,
  b0_.privilege_label AS privilege_label_12,
  b0_.billing_type AS billing_type_13,
  b0_.unit_price AS unit_price_14,
  b0_.quantity AS quantity_15,
  b0_.total_price AS total_price_16,
  b0_.currency AS currency_17,
  b0_.billing_status AS billing_status_18,
  b0_.billing_date AS billing_date_19,
  b0_.route AS route_20,
  b0_.ip AS ip_21,
  b0_.context AS context_22,
  b0_.created_at AS created_at_23
FROM
  billing_usage b0_
WHERE
  b0_.enseigne_id = ?
  AND b0_.billing_date >= ?
  AND b0_.billing_date < ?
ORDER BY
  b0_.billing_date DESC

SELECT b0_.id AS id_0, b0_.enseigne_id AS enseigne_id_1, b0_.enseigne_label AS enseigne_label_2, b0_.enseigne_code AS enseigne_code_3, b0_.user_uuid AS user_uuid_4, b0_.user_email AS user_email_5, b0_.user_full_name AS user_full_name_6, b0_.module_id AS module_id_7, b0_.module_label AS module_label_8, b0_.section_id AS section_id_9, b0_.section_label AS section_label_10, b0_.privilege_id AS privilege_id_11, b0_.privilege_label AS privilege_label_12, b0_.billing_type AS billing_type_13, b0_.unit_price AS unit_price_14, b0_.quantity AS quantity_15, b0_.total_price AS total_price_16, b0_.currency AS currency_17, b0_.billing_status AS billing_status_18, b0_.billing_date AS billing_date_19, b0_.route AS route_20, b0_.ip AS ip_21, b0_.context AS context_22, b0_.created_at AS created_at_23 FROM billing_usage b0_ WHERE b0_.enseigne_id = 33 AND b0_.billing_date >= '2026-09-01' AND b0_.billing_date < '2026-10-01' ORDER BY b0_.billing_date DESC;

SELECT
  b0_.billing_date AS billing_date_0,
  COUNT(b0_.id) AS sclr_1,
  SUM(b0_.quantity) AS sclr_2,
  SUM(b0_.total_price) AS sclr_3
FROM
  billing_usage b0_
WHERE
  b0_.billing_date >= ?
  AND b0_.billing_date < ?
GROUP BY
  b0_.billing_date
ORDER BY
  b0_.billing_date ASC

SELECT b0_.billing_date AS billing_date_0, COUNT(b0_.id) AS sclr_1, SUM(b0_.quantity) AS sclr_2, SUM(b0_.total_price) AS sclr_3 FROM billing_usage b0_ WHERE b0_.billing_date >= '2026-09-01' AND b0_.billing_date < '2026-10-01' GROUP BY b0_.billing_date ORDER BY b0_.billing_date ASC;

SELECT
  DATE_FORMAT(billing_date, '%Y-%m') AS month,
  COUNT(id) AS usage_count,
  SUM(quantity) AS quantity,
  SUM(total_price) AS total_amount
FROM
  billing_usage
WHERE
  billing_date >= ?
  AND billing_date < ?
GROUP BY
  DATE_FORMAT(billing_date, '%Y-%m')
ORDER BY
  month ASC

SELECT
                    DATE_FORMAT(billing_date, '%Y-%m') AS month,
                    COUNT(id) AS usage_count,
                    SUM(quantity) AS quantity,
                    SUM(total_price) AS total_amount
                FROM billing_usage
                WHERE billing_date >= '2026-04-01'
                  AND billing_date < '2026-10-01'
                GROUP BY DATE_FORMAT(billing_date, '%Y-%m')
                ORDER BY month ASC
            ;

SELECT
  t0.id AS id_1,
  t0.reference AS reference_2,
  t0.amount AS amount_3,
  t0.status AS status_4,
  t0.details AS details_5,
  t0.created_at AS created_at_6,
  t0.paid_at AS paid_at_7,
  t0.formule_enseigne_id AS formule_enseigne_id_8
FROM
  formule_enseigne_invoice t0
WHERE
  t0.formule_enseigne_id = ?

SELECT t0.id AS id_1, t0.reference AS reference_2, t0.amount AS amount_3, t0.status AS status_4, t0.details AS details_5, t0.created_at AS created_at_6, t0.paid_at AS paid_at_7, t0.formule_enseigne_id AS formule_enseigne_id_8 FROM formule_enseigne_invoice t0 WHERE t0.formule_enseigne_id = 64;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom AS nom_3,
  t0.libelle AS libelle_4,
  t0.main_url_root AS main_url_root_5,
  t0.main_document_root AS main_document_root_6,
  t0.main_url_root_alt AS main_url_root_alt_7,
  t0.main_document_root_alt AS main_document_root_alt_8,
  t0.main_data_root AS main_data_root_9,
  t0.main_db_host AS main_db_host_10,
  t0.main_db_port AS main_db_port_11,
  t0.main_db_name AS main_db_name_12,
  t0.main_db_prefix AS main_db_prefix_13,
  t0.main_db_user AS main_db_user_14,
  t0.main_db_pass AS main_db_pass_15,
  t0.main_db_type AS main_db_type_16,
  t0.main_db_character_set AS main_db_character_set_17,
  t0.main_db_collation AS main_db_collation_18,
  t0.main_authentication AS main_authentication_19,
  t0.main_prod AS main_prod_20,
  t0.main_force_https AS main_force_https_21,
  t0.main_restrict_os_commands AS main_restrict_os_commands_22,
  t0.nocsrfcheck AS nocsrfcheck_23,
  t0.main_instance_unique_id AS main_instance_unique_id_24,
  t0.mailing_limit_sendbyweb AS mailing_limit_sendbyweb_25,
  t0.main_distrib AS main_distrib_26,
  t0.environnement AS environnement_27,
  t0.statut AS statut_28,
  t0.etat_instance AS etat_instance_29,
  t0.version_courante AS version_courante_30,
  t0.health AS health_31,
  t0.base_url AS base_url_32,
  t0.api_key AS api_key_33,
  t0.dgi_token AS dgi_token_34,
  t0.last_heartbeat_at AS last_heartbeat_at_35,
  t0.created_at AS created_at_36,
  t0.updated_at AS updated_at_37,
  t0.active AS active_38
FROM
  enseignes t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.libelle AS libelle_4, t0.main_url_root AS main_url_root_5, t0.main_document_root AS main_document_root_6, t0.main_url_root_alt AS main_url_root_alt_7, t0.main_document_root_alt AS main_document_root_alt_8, t0.main_data_root AS main_data_root_9, t0.main_db_host AS main_db_host_10, t0.main_db_port AS main_db_port_11, t0.main_db_name AS main_db_name_12, t0.main_db_prefix AS main_db_prefix_13, t0.main_db_user AS main_db_user_14, t0.main_db_pass AS main_db_pass_15, t0.main_db_type AS main_db_type_16, t0.main_db_character_set AS main_db_character_set_17, t0.main_db_collation AS main_db_collation_18, t0.main_authentication AS main_authentication_19, t0.main_prod AS main_prod_20, t0.main_force_https AS main_force_https_21, t0.main_restrict_os_commands AS main_restrict_os_commands_22, t0.nocsrfcheck AS nocsrfcheck_23, t0.main_instance_unique_id AS main_instance_unique_id_24, t0.mailing_limit_sendbyweb AS mailing_limit_sendbyweb_25, t0.main_distrib AS main_distrib_26, t0.environnement AS environnement_27, t0.statut AS statut_28, t0.etat_instance AS etat_instance_29, t0.version_courante AS version_courante_30, t0.health AS health_31, t0.base_url AS base_url_32, t0.api_key AS api_key_33, t0.dgi_token AS dgi_token_34, t0.last_heartbeat_at AS last_heartbeat_at_35, t0.created_at AS created_at_36, t0.updated_at AS updated_at_37, t0.active AS active_38 FROM enseignes t0 WHERE t0.id = 33;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.active AS active_4,
  t0.prix AS prix_5,
  t0.photo AS photo_6,
  t0.max_simultaneous_connections AS max_simultaneous_connections_7,
  t0.price_per_hour AS price_per_hour_8,
  t0.billable_by_time AS billable_by_time_9
FROM
  formule t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.active AS active_4, t0.prix AS prix_5, t0.photo AS photo_6, t0.max_simultaneous_connections AS max_simultaneous_connections_7, t0.price_per_hour AS price_per_hour_8, t0.billable_by_time AS billable_by_time_9 FROM formule t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.billing_type AS billing_type_3,
  t0.billing_unit AS billing_unit_4,
  t0.duration AS duration_5,
  t0.price AS price_6,
  t0.active AS active_7,
  t0.allow_overage AS allow_overage_8,
  t0.overage_multiplier AS overage_multiplier_9,
  t0.metadata AS metadata_10,
  t0.grace_period AS grace_period_11,
  t0.grace_unit AS grace_unit_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.formule_id AS formule_id_15
FROM
  billing_plan t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.billing_type AS billing_type_3, t0.billing_unit AS billing_unit_4, t0.duration AS duration_5, t0.price AS price_6, t0.active AS active_7, t0.allow_overage AS allow_overage_8, t0.overage_multiplier AS overage_multiplier_9, t0.metadata AS metadata_10, t0.grace_period AS grace_period_11, t0.grace_unit AS grace_unit_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.formule_id AS formule_id_15 FROM billing_plan t0 WHERE t0.id = 2;