Symfony Profiler

[
  "route" => "admin_invoice_index"
  "route_parameters" => [
    "_route" => "admin_invoice_index"
    "_locale" => "fr"
    "_controller" => "App\Controller\Admin\InvoiceCrudController::index"
    "routeCreatedByEasyAdmin" => true
    "dashboardControllerFqcn" => "App\Controller\Admin\DashboardController"
    "crudControllerFqcn" => "App\Controller\Admin\InvoiceCrudController"
    "crudAction" => "index"
  ]
  "request_uri" => "https://entreprise.v2.mageconsulting.fr/fr/admin/invoice"
  "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 {#1012
      +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 {#1012
      +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 {#1012
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT DISTINCT i0_.id AS id_0, i0_.creation_date AS creation_date_1 FROM invoice i0_ WHERE i0_.company_id = ? ORDER BY i0_.creation_date DESC LIMIT 20"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1012
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT i0_.id AS id_0, i0_.code AS code_1, i0_.paid AS paid_2, i0_.creation_date AS creation_date_3, i0_.due_date AS due_date_4, i0_.total_ht AS total_ht_5, i0_.mail_sent AS mail_sent_6, i0_.total_ttc AS total_ttc_7, i0_.tva AS tva_8, i0_.relance AS relance_9, i0_.timbre AS timbre_10, i0_.status AS status_11, i0_.company_id AS company_id_12, i0_.customer_id AS customer_id_13 FROM invoice i0_ WHERE i0_.company_id = ? AND i0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY i0_.creation_date DESC"
  "params" => [
    1 => 1
    2 => 161
    3 => 124
    4 => 102
    5 => 103
    6 => 101
    7 => 100
    8 => 99
    9 => 98
    10 => 95
    11 => 96
    12 => 97
    13 => 92
    14 => 93
    15 => 94
    16 => 90
    17 => 91
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1012
      +name: "INTEGER"
    }
    2 => Doctrine\DBAL\ParameterType {#1012}
    3 => Doctrine\DBAL\ParameterType {#1012}
    4 => Doctrine\DBAL\ParameterType {#1012}
    5 => Doctrine\DBAL\ParameterType {#1012}
    6 => Doctrine\DBAL\ParameterType {#1012}
    7 => Doctrine\DBAL\ParameterType {#1012}
    8 => Doctrine\DBAL\ParameterType {#1012}
    9 => Doctrine\DBAL\ParameterType {#1012}
    10 => Doctrine\DBAL\ParameterType {#1012}
    11 => Doctrine\DBAL\ParameterType {#1012}
    12 => Doctrine\DBAL\ParameterType {#1012}
    13 => Doctrine\DBAL\ParameterType {#1012}
    14 => Doctrine\DBAL\ParameterType {#1012}
    15 => Doctrine\DBAL\ParameterType {#1012}
    16 => Doctrine\DBAL\ParameterType {#1012}
    17 => Doctrine\DBAL\ParameterType {#1012}
  ]
]

[
  "sql" => "SELECT count(*) AS sclr_0 FROM invoice i0_ WHERE i0_.company_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1012
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.email AS email_4, t0.phone AS phone_5, t0.address AS address_6, t0.siret AS siret_7, t0.tva AS tva_8, t0.price_precision AS price_precision_9, t0.company_id AS company_id_10, t0.currency_id AS currency_id_11 FROM customer t0 WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1012
      +name: "INTEGER"
    }
  ]
]

[
  "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 {#1012
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.email AS email_4, t0.phone AS phone_5, t0.address AS address_6, t0.siret AS siret_7, t0.tva AS tva_8, t0.price_precision AS price_precision_9, t0.company_id AS company_id_10, t0.currency_id AS currency_id_11 FROM customer t0 WHERE t0.id = ?"
  "params" => [
    1 => 14
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1012
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.email AS email_4, t0.phone AS phone_5, t0.address AS address_6, t0.siret AS siret_7, t0.tva AS tva_8, t0.price_precision AS price_precision_9, t0.company_id AS company_id_10, t0.currency_id AS currency_id_11 FROM customer t0 WHERE t0.id = ?"
  "params" => [
    1 => 13
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1012
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.email AS email_4, t0.phone AS phone_5, t0.address AS address_6, t0.siret AS siret_7, t0.tva AS tva_8, t0.price_precision AS price_precision_9, t0.company_id AS company_id_10, t0.currency_id AS currency_id_11 FROM customer t0 WHERE t0.id = ?"
  "params" => [
    1 => 11
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1012
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.email AS email_4, t0.phone AS phone_5, t0.address AS address_6, t0.siret AS siret_7, t0.tva AS tva_8, t0.price_precision AS price_precision_9, t0.company_id AS company_id_10, t0.currency_id AS currency_id_11 FROM customer t0 WHERE t0.id = ?"
  "params" => [
    1 => 12
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1012
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT SUM(i0_.total_ht) AS sclr_0 FROM invoice i0_ WHERE i0_.company_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1012
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT SUM(i0_.tva) AS sclr_0 FROM invoice i0_ WHERE i0_.company_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1012
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT SUM(i0_.timbre) AS sclr_0 FROM invoice i0_ WHERE i0_.company_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1012
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT SUM(i0_.total_ttc) AS sclr_0 FROM invoice i0_ WHERE i0_.company_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1012
      +name: "INTEGER"
    }
  ]
]

[
  "key" => "_security_main"
]