Symfony Profiler

[
  "route" => "_api_/sales_orders{._format}_get_collection"
  "route_parameters" => [
    "_route" => "_api_/sales_orders{._format}_get_collection"
    "_controller" => "api_platform.symfony.main_controller"
    "_stateless" => false
    "_api_resource_class" => "App\Entity\Exact\SalesOrders"
    "_api_operation_name" => "_api_/sales_orders{._format}_get_collection"
    "_format" => null
  ]
  "request_uri" => "https://internal.ventilatiebaas.nl/api/sales_orders?orderNumber=4473&page=1"
  "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"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => 3306
    "user" => "internalventilatiebaas"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "internalventilatiebaas"
    "serverVersion" => "10.11.13-MariaDB-0ubuntu0.24.04.1"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT count(DISTINCT e0_.id) AS sclr_0 FROM exact_sales_orders e0_ INNER JOIN exact_accounts e1_ ON e0_.deliver_to_id = e1_.id INNER JOIN exact_accounts e2_ ON e0_.invoice_to_id = e2_.id LEFT JOIN exact_contacts e3_ ON e0_.deliver_to_contact_id = e3_.id LEFT JOIN exact_contacts e4_ ON e0_.invoice_to_contact_id = e4_.id WHERE e0_.order_number = ?"
  "params" => [
    1 => "4473"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1129
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT e0_.id AS id_0, e0_.exact_id AS exact_id_1, e0_.order_id AS order_id_2, e0_.created AS created_3, e0_.timestamp AS timestamp_4, e0_.order_number AS order_number_5, e0_.delivery_date AS delivery_date_6, e0_.description AS description_7, e0_.remarks AS remarks_8, e0_.client_ref AS client_ref_9, e1_.id AS id_10, e1_.exact_id AS exact_id_11, e1_.code AS code_12, e1_.created AS created_13, e1_.email AS email_14, e1_.name AS name_15, e1_.timestamp AS timestamp_16, e1_.address_line1 AS address_line1_17, e1_.address_line2 AS address_line2_18, e1_.address_line3 AS address_line3_19, e1_.blocked AS blocked_20, e1_.auto_import AS auto_import_21, e1_.city AS city_22, e1_.country AS country_23, e1_.country_name AS country_name_24, e1_.phone AS phone_25, e1_.postcode AS postcode_26, e1_.remarks AS remarks_27, e1_.status AS status_28, e1_.website AS website_29, e2_.id AS id_30, e2_.exact_id AS exact_id_31, e2_.code AS code_32, e2_.created AS created_33, e2_.email AS email_34, e2_.name AS name_35, e2_.timestamp AS timestamp_36, e2_.address_line1 AS address_line1_37, e2_.address_line2 AS address_line2_38, e2_.address_line3 AS address_line3_39, e2_.blocked AS blocked_40, e2_.auto_import AS auto_import_41, e2_.city AS city_42, e2_.country AS country_43, e2_.country_name AS country_name_44, e2_.phone AS phone_45, e2_.postcode AS postcode_46, e2_.remarks AS remarks_47, e2_.status AS status_48, e2_.website AS website_49, e3_.id AS id_50, e3_.exact_id AS exact_id_51, e3_.code AS code_52, e3_.created AS created_53, e3_.email AS email_54, e3_.timestamp AS timestamp_55, e3_.firstname AS firstname_56, e3_.lastname AS lastname_57, e3_.middlename AS middlename_58, e3_.phone AS phone_59, e3_.mobile AS mobile_60, e3_.auto_import AS auto_import_61, e4_.id AS id_62, e4_.exact_id AS exact_id_63, e4_.code AS code_64, e4_.created AS created_65, e4_.email AS email_66, e4_.timestamp AS timestamp_67, e4_.firstname AS firstname_68, e4_.lastname AS lastname_69, e4_.middlename AS middlename_70, e4_.phone AS phone_71, e4_.mobile AS mobile_72, e4_.auto_import AS auto_import_73, e0_.deliver_to_id AS deliver_to_id_74, e0_.invoice_to_id AS invoice_to_id_75, e0_.deliver_to_contact_id AS deliver_to_contact_id_76, e0_.invoice_to_contact_id AS invoice_to_contact_id_77, e3_.account_id AS account_id_78, e4_.account_id AS account_id_79 FROM exact_sales_orders e0_ INNER JOIN exact_accounts e1_ ON e0_.deliver_to_id = e1_.id INNER JOIN exact_accounts e2_ ON e0_.invoice_to_id = e2_.id LEFT JOIN exact_contacts e3_ ON e0_.deliver_to_contact_id = e3_.id LEFT JOIN exact_contacts e4_ ON e0_.invoice_to_contact_id = e4_.id WHERE e0_.order_number = ? ORDER BY e0_.id ASC LIMIT 30"
  "params" => [
    1 => "4473"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1129
      +name: "STRING"
    }
  ]
]