GET https://magmaerp-n2a.myn2a.online/client/create

Query Metrics

35 Database Queries
25 Different statements
10.13 ms Query time
4 Invalid entities
46 Managed entities

Queries

Group similar statements

# Time Info
1 0.93 ms
SELECT t0.clef AS clef_1, t0.valeur AS valeur_2 FROM app_config t0 WHERE t0.clef = ?
Parameters:
[
  "maintenance_mode"
]
2 0.30 ms
SELECT t0.clef AS clef_1, t0.valeur AS valeur_2 FROM app_config t0 WHERE t0.clef = ?
Parameters:
[
  "maintenance_resume_at"
]
3 0.54 ms
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 = ?
Parameters:
[
  "759d4938-4a3a-4c94-b244-28d1bf506b0f"
]
4 0.29 ms
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
Parameters:
[
  "gbenagnonagbannon@gmail.com"
]
5 0.38 ms
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 = ?
Parameters:
[
  33
]
6 0.36 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.slug AS slug_4, t0.description AS description_5, t0.route AS route_6, t0.route_name AS route_name_7, t0.category AS category_8, t0.image_url AS image_url_9, t0.active AS active_10, t0.critical AS critical_11, t0.billable AS billable_12, t0.price_per_minute AS price_per_minute_13, t0.credit_cost AS credit_cost_14, t0.usage_cost AS usage_cost_15, t0.override_formula_billing AS override_formula_billing_16, t0.usage_count AS usage_count_17, t0.denied_count AS denied_count_18, t0.total_usage_seconds AS total_usage_seconds_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t22.id AS id_23, t22.titre AS titre_24, t22.description AS description_25, t22.active AS active_26, t22.privilege_id AS privilege_id_27, t22.category_id AS category_id_28, t22.release_id AS release_id_29, t0.section_id AS section_id_30 FROM privilege t0 LEFT JOIN documentation_privilege t22 ON t22.privilege_id = t0.id WHERE t0.route = ? LIMIT 1
Parameters:
[
  "client-create"
]
7 0.40 ms
SELECT f0_.id AS id_0, f0_.enseigne_id AS enseigne_id_1, f0_.enseigne_nom AS enseigne_nom_2, f0_.code_enseigne AS code_enseigne_3, f0_.last_business_sync_at AS last_business_sync_at_4, f0_.formule_nom AS formule_nom_5, f0_.active AS active_6, f0_.billing_mode AS billing_mode_7, f0_.premium_users_limit AS premium_users_limit_8, f0_.max_collaborateurs AS max_collaborateurs_9, f0_.total_connexion_minutes AS total_connexion_minutes_10, f0_.usage_billing_enabled AS usage_billing_enabled_11, f0_.temporary_start_at AS temporary_start_at_12, f0_.temporary_end_at AS temporary_end_at_13, f0_.hours_purchased AS hours_purchased_14, f0_.days_purchased AS days_purchased_15, f0_.custom_price AS custom_price_16, f0_.created_at AS created_at_17, f0_.updated_at AS updated_at_18, f0_.subscribed_at AS subscribed_at_19, f0_.last_renewal_at AS last_renewal_at_20, f0_.next_renewal_at AS next_renewal_at_21, f0_.auto_renew AS auto_renew_22, f0_.renewal_attempts AS renewal_attempts_23, f0_.grace_period_end_at AS grace_period_end_at_24, f0_.suspended_at AS suspended_at_25, f0_.suspension_reason AS suspension_reason_26, f0_.cancelled_at AS cancelled_at_27, f0_.enseigne_id AS enseigne_id_28, f0_.formule_id AS formule_id_29, f0_.billing_plan_id AS billing_plan_id_30 FROM formule_enseigne f0_ WHERE f0_.code_enseigne = ? AND f0_.active = 1 ORDER BY f0_.id DESC LIMIT 1
Parameters:
[
  "LQNJ"
]
8 0.31 ms
SELECT f0_.id AS id_0, f0_.enseigne_id AS enseigne_id_1, f0_.enseigne_nom AS enseigne_nom_2, f0_.code_enseigne AS code_enseigne_3, f0_.last_business_sync_at AS last_business_sync_at_4, f0_.formule_nom AS formule_nom_5, f0_.active AS active_6, f0_.billing_mode AS billing_mode_7, f0_.premium_users_limit AS premium_users_limit_8, f0_.max_collaborateurs AS max_collaborateurs_9, f0_.total_connexion_minutes AS total_connexion_minutes_10, f0_.usage_billing_enabled AS usage_billing_enabled_11, f0_.temporary_start_at AS temporary_start_at_12, f0_.temporary_end_at AS temporary_end_at_13, f0_.hours_purchased AS hours_purchased_14, f0_.days_purchased AS days_purchased_15, f0_.custom_price AS custom_price_16, f0_.created_at AS created_at_17, f0_.updated_at AS updated_at_18, f0_.subscribed_at AS subscribed_at_19, f0_.last_renewal_at AS last_renewal_at_20, f0_.next_renewal_at AS next_renewal_at_21, f0_.auto_renew AS auto_renew_22, f0_.renewal_attempts AS renewal_attempts_23, f0_.grace_period_end_at AS grace_period_end_at_24, f0_.suspended_at AS suspended_at_25, f0_.suspension_reason AS suspension_reason_26, f0_.cancelled_at AS cancelled_at_27, f0_.enseigne_id AS enseigne_id_28, f0_.formule_id AS formule_id_29, f0_.billing_plan_id AS billing_plan_id_30 FROM formule_enseigne f0_ WHERE f0_.code_enseigne = ? AND f0_.active = 1 ORDER BY f0_.id DESC LIMIT 1
Parameters:
[
  "LQNJ"
]
9 0.16 ms
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 = ?
Parameters:
[
  5
]
10 0.28 ms
UPDATE user_platform_session SET active = ?, ended_at = ? WHERE last_activity_at < ? AND active = 1
Parameters:
[
  0
  "2026-09-12 03:40:24"
  "2026-09-12 03:10:24"
]
11 0.30 ms
SELECT COUNT(u0_.id) AS sclr_0 FROM user_platform_session u0_ WHERE u0_.enseigne_id = ? AND u0_.active = 1 AND u0_.last_activity_at >= ?
Parameters:
[
  33
  "2026-09-12 03:10:24"
]
12 0.31 ms
SELECT f0_.id AS id_0, f0_.enseigne_id AS enseigne_id_1, f0_.enseigne_nom AS enseigne_nom_2, f0_.code_enseigne AS code_enseigne_3, f0_.last_business_sync_at AS last_business_sync_at_4, f0_.formule_nom AS formule_nom_5, f0_.active AS active_6, f0_.billing_mode AS billing_mode_7, f0_.premium_users_limit AS premium_users_limit_8, f0_.max_collaborateurs AS max_collaborateurs_9, f0_.total_connexion_minutes AS total_connexion_minutes_10, f0_.usage_billing_enabled AS usage_billing_enabled_11, f0_.temporary_start_at AS temporary_start_at_12, f0_.temporary_end_at AS temporary_end_at_13, f0_.hours_purchased AS hours_purchased_14, f0_.days_purchased AS days_purchased_15, f0_.custom_price AS custom_price_16, f0_.created_at AS created_at_17, f0_.updated_at AS updated_at_18, f0_.subscribed_at AS subscribed_at_19, f0_.last_renewal_at AS last_renewal_at_20, f0_.next_renewal_at AS next_renewal_at_21, f0_.auto_renew AS auto_renew_22, f0_.renewal_attempts AS renewal_attempts_23, f0_.grace_period_end_at AS grace_period_end_at_24, f0_.suspended_at AS suspended_at_25, f0_.suspension_reason AS suspension_reason_26, f0_.cancelled_at AS cancelled_at_27, f0_.enseigne_id AS enseigne_id_28, f0_.formule_id AS formule_id_29, f0_.billing_plan_id AS billing_plan_id_30 FROM formule_enseigne f0_ WHERE f0_.enseigne_id = ? AND f0_.active = 1 ORDER BY f0_.id DESC LIMIT 1
Parameters:
[
  33
]
13 0.24 ms
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.user_nom AS user_nom_3, t0.user_email AS user_email_4, t0.role_label AS role_label_5, t0.unlimited_access AS unlimited_access_6, t0.bypass_connection_limit AS bypass_connection_limit_7, t0.bypass_billing AS bypass_billing_8, t0.price AS price_9, t0.active AS active_10, t0.metadata AS metadata_11, t0.started_at AS started_at_12, t0.expires_at AS expires_at_13, t0.created_at AS created_at_14, t0.formule_enseigne_id AS formule_enseigne_id_15, t0.user_uuid AS user_uuid_16 FROM formule_enseigne_premium_user t0 WHERE t0.user_uuid = ? AND t0.active = ? LIMIT 1
Parameters:
[
  "759d4938-4a3a-4c94-b244-28d1bf506b0f"
  1
]
14 0.21 ms
SELECT t0.id AS id_1, t0.privilege_id AS privilege_id_2, t0.privilege_nom AS privilege_nom_3, t0.price AS price_4, t0.billing_type AS billing_type_5, t0.started_at AS started_at_6, t0.expires_at AS expires_at_7, t0.active AS active_8, t0.created_at AS created_at_9, t0.formule_enseigne_id AS formule_enseigne_id_10 FROM formule_enseigne_privilege t0 WHERE t0.formule_enseigne_id = ?
Parameters:
[
  64
]
15 0.21 ms
SELECT t0.id AS id_1, t0.formule_id AS formule_id_2, t0.module_id AS module_id_3 FROM formule_module t0 WHERE t0.formule_id = ?
Parameters:
[
  5
]
16 0.29 ms
SELECT t0.id AS id_1, t0.formule_module_id AS formule_module_id_2, t0.section_id AS section_id_3 FROM formule_section t0 WHERE t0.formule_module_id = ?
Parameters:
[
  305
]
17 0.22 ms
SELECT t0.id AS id_1, t0.active AS active_2, t0.formule_section_id AS formule_section_id_3, t0.privilege_id AS privilege_id_4 FROM formule_privilege t0 WHERE t0.formule_section_id = ?
Parameters:
[
  836
]
18 0.27 ms
SELECT t0.id AS id_1, t0.active AS active_2, t0.formule_section_id AS formule_section_id_3, t0.privilege_id AS privilege_id_4 FROM formule_privilege t0 WHERE t0.formule_section_id = ?
Parameters:
[
  837
]
19 0.21 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.image_url AS image_url_4, t0.active AS active_5, t0.widgets_config AS widgets_config_6, t0.module_id AS module_id_7 FROM section t0 WHERE t0.id = ?
Parameters:
[
  2
]
20 0.20 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.active AS active_4, t0.image_url AS image_url_5 FROM module t0 WHERE t0.id = ?
Parameters:
[
  1
]
21 0.19 ms
SELECT t0.id AS id_1, t0.collaboration_id AS collaboration_id_2, t0.session_token AS session_token_3, t0.started_at AS started_at_4, t0.last_activity_at AS last_activity_at_5, t0.ended_at AS ended_at_6, t0.active AS active_7, t0.premium_user AS premium_user_8, t0.ip_address AS ip_address_9, t0.user_agent AS user_agent_10, t0.duration_seconds AS duration_seconds_11, t0.user_uuid AS user_uuid_12, t0.enseigne_id AS enseigne_id_13 FROM user_platform_session t0 WHERE t0.session_token = ? LIMIT 1
Parameters:
[
  "69702949d63a4d115be99b43b65467eb"
]
22 0.17 ms
"START TRANSACTION"
Parameters:
[]
23 0.23 ms
UPDATE user_platform_session SET last_activity_at = ? WHERE id = ?
Parameters:
[
  "2026-09-12 03:40:24"
  43
]
24 0.42 ms
"COMMIT"
Parameters:
[]
25 0.15 ms
"START TRANSACTION"
Parameters:
[]
26 0.31 ms
INSERT INTO billing_usage (enseigne_id, enseigne_label, enseigne_code, user_uuid, user_email, user_full_name, module_id, module_label, section_id, section_label, privilege_id, privilege_label, billing_type, unit_price, quantity, total_price, currency, billing_status, billing_date, route, ip, context, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  33
  "Helistorm Africa"
  "LQNJ"
  "759d4938-4a3a-4c94-b244-28d1bf506b0f"
  "gbenagnonagbannon@gmail.com"
  "Gbènagnon F. AGBANNON"
  1
  "TIERS"
  2
  "Clients"
  12
  "Nouveau client"
  "ACCESS"
  "1"
  "1"
  "1"
  "XOF"
  "PENDING"
  "2026-09-12"
  "client-create"
  "41.85.162.18"
  "{"session_id":43,"route":"client-create"}"
  "2026-09-12 03:40:24"
]
27 0.34 ms
"COMMIT"
Parameters:
[]
28 0.15 ms
"START TRANSACTION"
Parameters:
[]
29 0.32 ms
INSERT INTO access_log (type, entity_id, entity_label, authorized, source, reason, log, route, ip, user_agent, enseigne_id, enseigne_label, enseigne_code, user_uuid, user_email, user_full_name, context, module_id, module_label, section_id, section_label, privilege_id, privilege_label, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "privilege"
  12
  "Nouveau client"
  1
  "FORMULE"
  "Inclus dans la formule"
  "GRANTED_FORMULE"
  "client-create"
  "41.85.162.18"
  "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/152.0.0.0 Safari/537.36"
  33
  "Helistorm Africa"
  "LQNJ"
  "759d4938-4a3a-4c94-b244-28d1bf506b0f"
  "gbenagnonagbannon@gmail.com"
  "Gbènagnon F. AGBANNON"
  "{"module_id":1,"module_name":"TIERS","section_id":2,"section_name":"Clients","privilege_id":12,"privilege_name":"Nouveau client","route":"client-create","ip":"41.85.162.18","user_agent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/152.0.0.0 Safari\/537.36","billing_status":null}"
  1
  "TIERS"
  2
  "Clients"
  12
  "Nouveau client"
  "2026-09-12 03:40:24"
]
30 0.30 ms
"COMMIT"
Parameters:
[]
31 0.35 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.enseigne_id AS enseigne_id_3, t0.enseigne_label AS enseigne_label_4, t0.enseigne_code AS enseigne_code_5, t0.module_id AS module_id_6, t0.module_label AS module_label_7, t0.section_id AS section_id_8, t0.section_label AS section_label_9, t0.privilege_id AS privilege_id_10, t0.privilege_label AS privilege_label_11, t0.unique_users AS unique_users_12, t0.users AS users_13, t0.total_hits AS total_hits_14, t0.authorized_hits AS authorized_hits_15, t0.denied_hits AS denied_hits_16, t0.billable_hits AS billable_hits_17, t0.unit_price AS unit_price_18, t0.total_amount AS total_amount_19, t0.metadata AS metadata_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22 FROM usage_aggregate t0 WHERE t0.date = ? AND t0.enseigne_id = ? AND t0.module_id = ? AND t0.section_id = ? AND t0.privilege_id = ? LIMIT 1
Parameters:
[
  "2026-09-12"
  33
  1
  2
  12
]
32 0.11 ms
"START TRANSACTION"
Parameters:
[]
33 0.22 ms
INSERT INTO billing_usage (enseigne_id, enseigne_label, enseigne_code, user_uuid, user_email, user_full_name, module_id, module_label, section_id, section_label, privilege_id, privilege_label, billing_type, unit_price, quantity, total_price, currency, billing_status, billing_date, route, ip, context, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  33
  "Helistorm Africa"
  "LQNJ"
  "759d4938-4a3a-4c94-b244-28d1bf506b0f"
  "gbenagnonagbannon@gmail.com"
  "Gbènagnon F. AGBANNON"
  1
  "TIERS"
  2
  "Clients"
  12
  "Nouveau client"
  "ACCESS"
  "2"
  "1"
  "2"
  "XOF"
  "PENDING"
  "2026-09-12"
  "client-create"
  "41.85.162.18"
  "{"module_id":1,"module_name":"TIERS","section_id":2,"section_name":"Clients","privilege_id":12,"privilege_name":"Nouveau client","route":"client-create","ip":"41.85.162.18","user_agent":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/152.0.0.0 Safari\/537.36","billing_status":null}"
  "2026-09-12 03:40:24"
]
34 0.17 ms
UPDATE usage_aggregate SET total_hits = ? WHERE id = ?
Parameters:
[
  3
  56
]
35 0.29 ms
"COMMIT"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\FormuleModule 10
App\Entity\Module 10
App\Entity\Privilege 4
App\Entity\FormulePrivilege 4
App\Entity\Section 3
App\Entity\FormuleSection 3
App\Entity\AppConfig 2
App\Entity\BillingUsage 2
App\Entity\Users 1
App\Entity\Enseigne 1
App\Entity\FormuleEnseigne 1
App\Entity\Formule 1
App\Entity\BillingPlan 1
App\Entity\UserPlatformSession 1
App\Entity\AccessLog 1
App\Entity\UsageAggregate 1

Entities Mapping

Class Mapping errors
App\Entity\AppConfig No errors.
App\Entity\Users No errors.
App\Entity\Enseigne No errors.
App\Entity\Privilege No errors.
App\Entity\DocumentationPrivilege
  • The field App\Entity\DocumentationPrivilege#feedbacks is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\DocumentationFeedback#documentation does not contain the required 'inversedBy="feedbacks"' attribute.
  • The field App\Entity\DocumentationPrivilege#videos is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\DocumentationVideo#documentation does not contain the required 'inversedBy="videos"' attribute.
App\Entity\DocumentationCategory
  • The field App\Entity\DocumentationCategory#documentations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\DocumentationPrivilege#category does not contain the required 'inversedBy="documentations"' attribute.
App\Entity\DocumentationRelease
  • The field App\Entity\DocumentationRelease#documentations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\DocumentationPrivilege#release does not contain the required 'inversedBy="documentations"' attribute.
App\Entity\Section No errors.
App\Entity\PrivilegeGroup No errors.
App\Entity\FormuleEnseigne No errors.
App\Entity\Formule No errors.
App\Entity\BillingPlan No errors.
App\Entity\FormuleEnseignePrivilege No errors.
App\Entity\FormuleEnseigneModule No errors.
App\Entity\FormuleEnseigneTemplate No errors.
App\Entity\FormuleEnseigneUsage No errors.
App\Entity\FormuleEnseignePremiumUser No errors.
App\Entity\FormuleEnseigneInvoice
  • The field App\Entity\FormuleEnseigneInvoice#payments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\BillingPayment#invoice does not contain the required 'inversedBy="payments"' attribute.
App\Entity\FormuleModule No errors.
App\Entity\FormuleAddon No errors.
App\Entity\UserPlatformSession No errors.
App\Entity\Module No errors.
App\Entity\FormuleSection No errors.
App\Entity\FormulePrivilege No errors.
App\Entity\BillingUsage No errors.
App\Entity\AccessLog No errors.
App\Entity\UsageAggregate No errors.