Symfony Profiler

[
  "route" => "app_apifront_category_listdetailed"
  "route_parameters" => [
    "_route" => "app_apifront_category_listdetailed"
    "_controller" => "App\Controller\ApiFront\CategoryController::listDetailed"
  ]
  "request_uri" => "https://api.oceannoak.com/api-front/category/list-detailed?type=1"
  "method" => "GET"
]

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

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

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

[
  "method" => "GET"
  "path" => "/api-front/category/list-detailed"
  "request" => []
  "query" => [
    "type" => "1"
  ]
  "body" => ""
  "ip" => "139.59.212.105"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "127.0.0.1"
    "port" => null
    "user" => "root"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "ocean_and_oak"
    "serverVersion" => "8.0"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.img AS img_2, c0_.description AS description_3, c0_.type AS type_4, c0_.priority AS priority_5, c0_.slogan AS slogan_6, c0_.created_at AS created_at_7, c0_.deleted_at AS deleted_at_8, p1_.id AS id_9, p1_.name AS name_10, p1_.thumbnail_type AS thumbnail_type_11, p1_.img AS img_12, p1_.video AS video_13, p1_.price AS price_14, p1_.description AS description_15, p1_.priority AS priority_16, p1_.created_at AS created_at_17, p1_.deleted_at AS deleted_at_18, p1_.category_id AS category_id_19 FROM category c0_ LEFT JOIN product p1_ ON c0_.id = p1_.category_id AND (p1_.deleted_at IS NULL) WHERE (c0_.type = ?) AND (c0_.deleted_at IS NULL) ORDER BY p1_.priority ASC, c0_.priority ASC"
  "params" => [
    1 => "1"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = ?"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = ?"
  "params" => [
    1 => 13
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3 FROM tag t0 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => 1
  ]
]

[
  "status" => 200
  "path" => "/api-front/category/list-detailed"
  "response" => "{"status":1,"data":[{"id":4,"name":"Waffles","slogan":null,"img":"https:\/\/api.oceannoak.com\/image\/category\/category\/17756597507976_4511aa9c2051574fab702f3f02ed662c.jpg","description":"Waffles","type":1,"products":[{"id":5,"name":"Fruit \u0026 Ice Cream Waffle","thumbnailType":1,"img":"https:\/\/api.oceannoak.com\/image\/product\/product\/17756597824916_44cfba7c9562c337e2a35fb178146335.jpg","video":null,"tagNames":[],"price":10,"description":"Fresh fruit, vanilla ice cream","createdAt":1775659782},{"id":6,"name":"Nutella Fruit Waffle","thumbnailType":1,"img":"https:\/\/api.oceannoak.com\/image\/product\/product\/17756598069537_d0c9b9cc6f1f7cbc498ecf21d36992c7.jpg","video":null,"tagNames":[],"price":15,"description":"Nutella, berries, banana","createdAt":1775659806}]},{"id":5,"name":"Pancakes","slogan":null,"img":"https:\/\/api.oceannoak.com\/image\/category\/category\/1775659866456_d03639da73d36cf864ce0d1de6e4532a.jpg","description":"Stacked High","type":1,"products":[{"id":7,"name":"Ricotta Pancakes","thumbnailType":1,"img":"https:\/\/api.oceannoak.com\/image\/product\/product\/17756598881423_90356c33ab3b28fc74194ce0dfe5571c.jpg","video":null,"tagNames":[],"price":10,"description":"Three ricotta pancakes, fresh berries","createdAt":1775659888},{"id":13,"name":"Fresh Croissants","thumbnailType":2,"img":"https:\/\/api.oceannoak.com\/image\/product\/product\/17761786193189_8df93220cb57a7e514198710bb5ff962.png","video":"https:\/\/api.oceannoak.com\/file\/product\/17761786193193_b32fe7bf605c13d5ca52e768d614c89e.mp4","tagNames":[],"price":10,"description":null,"createdAt":1776178619}]},{"id":6,"name":"Drinks","slogan":null,"img":"https:\/\/api.oceannoak.com\/image\/category\/category\/17759121770279_f73ae2594128dcfd3e70e1760a9f704f.png","description":null,"type":1,"products":[{"id":8,"name":"Morning Coffee","thumbnailType":2,"img":"https:\/\/api.oceannoak.com\/image\/product\/product\/17759122250115_366f58d9a2f51f2a3924cf5ce20471e8.png","video":"https:\/\/api.oceannoak.com\/file\/product\/17759122250118_c178624776ecfae34233960221d03195.mp4","tagNames":["Organic"],"price":2,"description":"Artisan roasts brewed to perfection. Rich, smooth, and aromatic \u2014 the ideal way to start your coastal morning.","createdAt":1775912225}]}]}"
]