Symfony Profiler

[
  "route" => "api_invoice_list"
  "route_parameters" => [
    "_route" => "api_invoice_list"
    "_controller" => "App\Controller\Api\InvoiceApiController::list"
  ]
  "request_uri" => "https://invoice.mansa-portail.com/api/invoices?limit=200"
  "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" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "lyel0211_amansa_voyage"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "lyel0211_amansa_voyage"
    "serverVersion" => "10.11.2-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.active AS active_7, t0.must_change_password AS must_change_password_8, t0.created_at AS created_at_9, t0.last_login_at AS last_login_at_10, t0.password_changed_at AS password_changed_at_11, t0.created_by_id AS created_by_id_12 FROM user t0 WHERE t0.id = ?"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#770
      +name: "INTEGER"
    }
  ]
]

[
  "provider" => "Symfony\Bridge\Doctrine\Security\User\EntityUserProvider"
  "username" => "amansavoyages@gmail.com"
]

[
  "sql" => "SELECT i0_.id AS id_0, i0_.type AS type_1, i0_.numero AS numero_2, i0_.date AS date_3, i0_.reference AS reference_4, i0_.client_nom AS client_nom_5, i0_.client_compte AS client_compte_6, i0_.client_extra AS client_extra_7, i0_.show_words AS show_words_8, i0_.upper AS upper_9, i0_.total AS total_10, i0_.created_at AS created_at_11, i0_.updated_at AS updated_at_12, COALESCE(SUM(p1_.amount), 0) AS sclr_13, i0_.client_id AS client_id_14, i0_.created_by_id AS created_by_id_15 FROM invoice i0_ LEFT JOIN payment p1_ ON i0_.id = p1_.invoice_id GROUP BY i0_.id ORDER BY i0_.date DESC, i0_.id DESC LIMIT 200"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.date AS date_2, t0.amount AS amount_3, t0.method AS method_4, t0.note AS note_5, t0.receipt_number AS receipt_number_6, t0.created_at AS created_at_7, t0.invoice_id AS invoice_id_8, t0.created_by_id AS created_by_id_9 FROM payment t0 WHERE t0.invoice_id = ? ORDER BY t0.date ASC, t0.id ASC"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#770
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.ref AS ref_3, t0.designation AS designation_4, t0.qte AS qte_5, t0.pu AS pu_6, t0.invoice_id AS invoice_id_7 FROM invoice_line t0 WHERE t0.invoice_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 3
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#770
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.date AS date_2, t0.amount AS amount_3, t0.method AS method_4, t0.note AS note_5, t0.receipt_number AS receipt_number_6, t0.created_at AS created_at_7, t0.invoice_id AS invoice_id_8, t0.created_by_id AS created_by_id_9 FROM payment t0 WHERE t0.invoice_id = ? ORDER BY t0.date ASC, t0.id ASC"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#770
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.ref AS ref_3, t0.designation AS designation_4, t0.qte AS qte_5, t0.pu AS pu_6, t0.invoice_id AS invoice_id_7 FROM invoice_line t0 WHERE t0.invoice_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#770
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.date AS date_2, t0.amount AS amount_3, t0.method AS method_4, t0.note AS note_5, t0.receipt_number AS receipt_number_6, t0.created_at AS created_at_7, t0.invoice_id AS invoice_id_8, t0.created_by_id AS created_by_id_9 FROM payment t0 WHERE t0.invoice_id = ? ORDER BY t0.date ASC, t0.id ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#770
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.ref AS ref_3, t0.designation AS designation_4, t0.qte AS qte_5, t0.pu AS pu_6, t0.invoice_id AS invoice_id_7 FROM invoice_line t0 WHERE t0.invoice_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#770
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.date AS date_2, t0.amount AS amount_3, t0.method AS method_4, t0.note AS note_5, t0.receipt_number AS receipt_number_6, t0.created_at AS created_at_7, t0.invoice_id AS invoice_id_8, t0.created_by_id AS created_by_id_9 FROM payment t0 WHERE t0.invoice_id = ? ORDER BY t0.date ASC, t0.id ASC"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#770
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.ref AS ref_3, t0.designation AS designation_4, t0.qte AS qte_5, t0.pu AS pu_6, t0.invoice_id AS invoice_id_7 FROM invoice_line t0 WHERE t0.invoice_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#770
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.date AS date_2, t0.amount AS amount_3, t0.method AS method_4, t0.note AS note_5, t0.receipt_number AS receipt_number_6, t0.created_at AS created_at_7, t0.invoice_id AS invoice_id_8, t0.created_by_id AS created_by_id_9 FROM payment t0 WHERE t0.invoice_id = ? ORDER BY t0.date ASC, t0.id ASC"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#770
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.ref AS ref_3, t0.designation AS designation_4, t0.qte AS qte_5, t0.pu AS pu_6, t0.invoice_id AS invoice_id_7 FROM invoice_line t0 WHERE t0.invoice_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#770
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.date AS date_2, t0.amount AS amount_3, t0.method AS method_4, t0.note AS note_5, t0.receipt_number AS receipt_number_6, t0.created_at AS created_at_7, t0.invoice_id AS invoice_id_8, t0.created_by_id AS created_by_id_9 FROM payment t0 WHERE t0.invoice_id = ? ORDER BY t0.date ASC, t0.id ASC"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#770
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.position AS position_2, t0.ref AS ref_3, t0.designation AS designation_4, t0.qte AS qte_5, t0.pu AS pu_6, t0.invoice_id AS invoice_id_7 FROM invoice_line t0 WHERE t0.invoice_id = ? ORDER BY t0.position ASC"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#770
      +name: "INTEGER"
    }
  ]
]

[
  "key" => "_security_main"
]