Symfony Profiler

[
  "route" => "admin"
  "route_parameters" => [
    "_route" => "admin"
    "_controller" => "App\Controller\Admin\DashboardController::index"
    "routeCreatedByEasyAdmin" => true
    "dashboardControllerFqcn" => "App\Controller\Admin\DashboardController"
    "crudControllerFqcn" => null
    "crudAction" => null
    "_locale" => "fr"
  ]
  "request_uri" => "https://entreprise.v2.mageconsulting.fr/fr/admin"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 1
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "swdb"
    "port" => null
    "user" => "gestion_commerciale_v2"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "gestion_commerciale_v2"
    "serverVersion" => "8.0"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.bio AS bio_7, t0.website AS website_8, t0.twitter_handle AS twitter_handle_9, t0.is_verified AS is_verified_10, t0.enabled AS enabled_11, t0.last_login_at AS last_login_at_12, t0.avatar AS avatar_13, t0.company_id AS company_id_14 FROM user t0 WHERE t0.id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#987
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.company_id AS company_id_4 FROM user_group t0 INNER JOIN user_user_group ON t0.id = user_user_group.user_group_id WHERE user_user_group.user_id = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#987
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "ali.samoudi@mageconsulting.fr"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.logo AS logo_4, t0.address AS address_5, t0.capital AS capital_6, t0.website AS website_7, t0.email AS email_8, t0.phone AS phone_9, t0.siret AS siret_10, t0.tva AS tva_11, t0.rcs AS rcs_12, t0.price_precision AS price_precision_13, t0.loi_pdf AS loi_pdf_14, t0.footer_pdf AS footer_pdf_15, t0.favicon AS favicon_16, t0.smtp_host AS smtp_host_17, t0.smtp_port AS smtp_port_18, t0.smtp_user AS smtp_user_19, t0.smtp_password AS smtp_password_20, t0.smtp_sender_email AS smtp_sender_email_21, t0.smtp_sender_name AS smtp_sender_name_22, t0.smtp_encryption AS smtp_encryption_23, t0.country_code AS country_code_24, t0.invoice_start_number AS invoice_start_number_25, t0.cra_email_template AS cra_email_template_26, t0.email_header AS email_header_27, t0.email_footer AS email_footer_28, t0.legal_form_id AS legal_form_id_29, t0.currency_id AS currency_id_30, t0.cachet AS cachet_31 FROM company t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#987
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.date_start AS date_start_3, t0.date_end AS date_end_4, t0.is_closed AS is_closed_5, t0.company_id AS company_id_6 FROM fiscal_period t0 WHERE t0.company_id = ? ORDER BY t0.date_start DESC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#987
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.bio AS bio_7, t0.website AS website_8, t0.twitter_handle AS twitter_handle_9, t0.is_verified AS is_verified_10, t0.enabled AS enabled_11, t0.last_login_at AS last_login_at_12, t0.avatar AS avatar_13, t0.company_id AS company_id_14 FROM user t0 WHERE t0.company_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#987
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.company_id AS company_id_4 FROM user_group t0 INNER JOIN user_user_group ON t0.id = user_user_group.user_group_id WHERE user_user_group.user_id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#987
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.company_id AS company_id_4 FROM user_group t0 INNER JOIN user_user_group ON t0.id = user_user_group.user_group_id WHERE user_user_group.user_id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#987
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT COUNT(u0_.id) AS sclr_0 FROM user u0_ WHERE u0_.company_id = ? AND u0_.last_login_at >= ?"
  "params" => [
    1 => 1
    2 => "2026-07-14 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#987
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1642
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT c0_.name AS name_0, SUM(i1_.total_ht) AS sclr_1 FROM invoice i1_ INNER JOIN customer c0_ ON i1_.customer_id = c0_.id WHERE i1_.company_id = ? AND i1_.creation_date >= ? AND i1_.creation_date <= ? GROUP BY c0_.name"
  "params" => [
    1 => 1
    2 => "2025-10-01 00:00:00"
    3 => "2026-09-30 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#987
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1642
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1642}
  ]
]

[
  "sql" => "SELECT u0_.full_name AS full_name_0, SUM(c1_.total_excl_tax) AS sclr_1 FROM consultant_invoice c1_ INNER JOIN activity_report a2_ ON c1_.activity_report_id = a2_.id INNER JOIN user u0_ ON a2_.consultant_id = u0_.id WHERE c1_.company_id = ? AND c1_.created_at >= ? AND c1_.created_at <= ? GROUP BY u0_.full_name"
  "params" => [
    1 => 1
    2 => "2025-10-01 00:00:00"
    3 => "2026-09-30 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#987
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1642
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1642}
  ]
]

[
  "sql" => "SELECT b0_.transaction_date AS transaction_date_0, b0_.amount_ht AS amount_ht_1, b0_.amount AS amount_2, b0_.amount_tva AS amount_tva_3 FROM bank_transaction b0_ LEFT JOIN classify c1_ ON b0_.classify_id = c1_.id WHERE b0_.company_id = ? AND b0_.transaction_type = ? AND (c1_.label NOT LIKE ? OR c1_.label IS NULL) AND (c1_.out_of_kpi = 0 OR c1_.id IS NULL) AND b0_.fiscal_period_id = ?"
  "params" => [
    1 => 1
    2 => "DEBIT"
    3 => "%TVA%"
    4 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#987
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1642
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1642}
    4 => Doctrine\DBAL\ParameterType {#987}
  ]
]

[
  "sql" => "SELECT b0_.transaction_date AS transaction_date_0, b0_.amount_ht AS amount_ht_1, b0_.amount AS amount_2, b0_.amount_tva AS amount_tva_3 FROM bank_transaction b0_ LEFT JOIN classify c1_ ON b0_.classify_id = c1_.id WHERE b0_.company_id = ? AND b0_.transaction_type = ? AND (c1_.out_of_kpi = 0 OR c1_.id IS NULL) AND b0_.fiscal_period_id = ?"
  "params" => [
    1 => 1
    2 => "CREDIT"
    3 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#987
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1642
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#987}
  ]
]

[
  "sql" => "SELECT i0_.creation_date AS creation_date_0, i0_.total_ht AS total_ht_1 FROM invoice i0_ WHERE i0_.company_id = ? AND i0_.creation_date >= ? AND i0_.creation_date <= ?"
  "params" => [
    1 => 1
    2 => "2025-10-01 00:00:00"
    3 => "2026-09-30 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#987
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1642
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1642}
  ]
]

[
  "sql" => "SELECT c0_.created_at AS created_at_0, c0_.total_excl_tax AS total_excl_tax_1 FROM consultant_invoice c0_ WHERE c0_.company_id = ? AND c0_.created_at >= ? AND c0_.created_at <= ?"
  "params" => [
    1 => 1
    2 => "2025-10-01 00:00:00"
    3 => "2026-09-30 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#987
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1642
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1642}
  ]
]

[
  "sql" => "SELECT s0_.creation_date AS creation_date_0, s0_.total_ht AS total_ht_1 FROM supplier_invoice s0_ WHERE s0_.company_id = ? AND s0_.creation_date >= ? AND s0_.creation_date <= ?"
  "params" => [
    1 => 1
    2 => "2025-10-01 00:00:00"
    3 => "2026-09-30 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#987
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1642
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1642}
  ]
]

[
  "sql" => "SELECT b0_.transaction_date AS transaction_date_0, b0_.amount_ht AS amount_ht_1, b0_.amount AS amount_2 FROM bank_transaction b0_ LEFT JOIN classify c1_ ON b0_.classify_id = c1_.id WHERE b0_.company_id = ? AND b0_.transaction_type = ? AND ((c1_.label NOT LIKE ? AND c1_.label NOT LIKE ? AND c1_.label NOT LIKE ?) OR c1_.label IS NULL) AND (c1_.out_of_kpi = 0 OR c1_.id IS NULL) AND b0_.fiscal_period_id = ?"
  "params" => [
    1 => 1
    2 => "DEBIT"
    3 => "%Fournisseur%"
    4 => "%TVA%"
    5 => "%Porteur%"
    6 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#987
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1642
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1642}
    4 => Doctrine\DBAL\ParameterType {#1642}
    5 => Doctrine\DBAL\ParameterType {#1642}
    6 => Doctrine\DBAL\ParameterType {#987}
  ]
]

[
  "sql" => "SELECT c0_.label AS label_0, SUM(COALESCE(b1_.amount_ht, b1_.amount)) AS sclr_1 FROM bank_transaction b1_ LEFT JOIN classify c0_ ON b1_.classify_id = c0_.id WHERE b1_.company_id = ? AND b1_.transaction_type = ? AND (c0_.out_of_kpi = 0 OR c0_.id IS NULL) AND b1_.fiscal_period_id = ? GROUP BY c0_.label"
  "params" => [
    1 => 1
    2 => "DEBIT"
    3 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#987
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1642
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#987}
  ]
]

[
  "sql" => "SELECT SUM(COALESCE(b0_.amount_ht, b0_.amount)) AS sclr_0 FROM bank_transaction b0_ LEFT JOIN classify c1_ ON b0_.classify_id = c1_.id WHERE b0_.company_id = ? AND b0_.transaction_type = ? AND (c1_.out_of_kpi = 0 OR c1_.id IS NULL) AND ((c1_.label NOT LIKE ? AND c1_.label NOT LIKE ? AND c1_.label NOT LIKE ?) OR c1_.label IS NULL) AND b0_.fiscal_period_id = ?"
  "params" => [
    1 => 1
    2 => "DEBIT"
    3 => "%Fournisseur%"
    4 => "%TVA%"
    5 => "%Porteur%"
    6 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#987
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1642
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1642}
    4 => Doctrine\DBAL\ParameterType {#1642}
    5 => Doctrine\DBAL\ParameterType {#1642}
    6 => Doctrine\DBAL\ParameterType {#987}
  ]
]

[
  "sql" => "SELECT SUM(s0_.total_ht) AS sclr_0 FROM supplier_invoice s0_ WHERE s0_.company_id = ? AND s0_.creation_date >= ? AND s0_.creation_date <= ?"
  "params" => [
    1 => 1
    2 => "2025-10-01 00:00:00"
    3 => "2026-09-30 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#987
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1642
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1642}
  ]
]

[
  "sql" => "SELECT SUM(i0_.tva) AS sclr_0 FROM invoice i0_ WHERE i0_.company_id = ? AND i0_.creation_date >= ? AND i0_.creation_date <= ?"
  "params" => [
    1 => 1
    2 => "2025-10-01 00:00:00"
    3 => "2026-09-30 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#987
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1642
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1642}
  ]
]

[
  "sql" => "SELECT SUM(c0_.vat_amount) AS sclr_0 FROM consultant_invoice c0_ WHERE c0_.company_id = ? AND c0_.created_at >= ? AND c0_.created_at <= ?"
  "params" => [
    1 => 1
    2 => "2025-10-01 00:00:00"
    3 => "2026-09-30 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#987
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1642
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1642}
  ]
]

[
  "sql" => "SELECT SUM(b0_.amount_tva) AS sclr_0 FROM bank_transaction b0_ LEFT JOIN classify c1_ ON b0_.classify_id = c1_.id WHERE b0_.company_id = ? AND b0_.transaction_type = ? AND (c1_.label NOT LIKE ? OR c1_.label IS NULL) AND (c1_.out_of_kpi = 0 OR c1_.id IS NULL) AND b0_.fiscal_period_id = ?"
  "params" => [
    1 => 1
    2 => "DEBIT"
    3 => "%Fournisseur%"
    4 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#987
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1642
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1642}
    4 => Doctrine\DBAL\ParameterType {#987}
  ]
]

[
  "sql" => "SELECT SUM(b0_.amount_ht) AS sclr_0 FROM bank_transaction b0_ INNER JOIN classify c1_ ON b0_.classify_id = c1_.id WHERE b0_.company_id = ? AND b0_.transaction_type = ? AND c1_.label = ? AND c1_.out_of_kpi = 0 AND b0_.fiscal_period_id = ?"
  "params" => [
    1 => 1
    2 => "DEBIT"
    3 => "TVA"
    4 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#987
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1642
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1642}
    4 => Doctrine\DBAL\ParameterType {#987}
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.days AS days_1, a0_.date AS date_2, a0_.created_at AS created_at_3, a0_.pdf AS pdf_4, a0_.invoice_pdf AS invoice_pdf_5, a0_.holidays AS holidays_6, a0_.validated AS validated_7, a0_.invoiced AS invoiced_8, a0_.is_package AS is_package_9, a0_.company_id AS company_id_10, a0_.consultant_id AS consultant_id_11, a0_.purchase_order_id AS purchase_order_id_12 FROM activity_report a0_ WHERE a0_.company_id = ? AND a0_.date >= ? AND a0_.date <= ?"
  "params" => [
    1 => 1
    2 => "2026-07-01 00:00:00"
    3 => "2026-07-31 00:00:00"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#987
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1642
      +name: "STRING"
    }
    3 => Doctrine\DBAL\ParameterType {#1642}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.symbol AS symbol_4 FROM currency t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#987
      +name: "INTEGER"
    }
  ]
]

[
  "key" => "_security_main"
]