GET https://api.oceannoak.com/api-front/category/list-detailed?type=1

Query Metrics

6 Database Queries
2 Different statements
2.74 ms Query time
0 Invalid entities
9 Managed entities

Queries

Group similar statements

# Time Info
1 0.94 ms
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
Parameters:
[
  "1"
]
2 0.56 ms
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 = ?
Parameters:
[
  5
]
3 0.35 ms
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 = ?
Parameters:
[
  6
]
4 0.33 ms
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 = ?
Parameters:
[
  7
]
5 0.30 ms
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 = ?
Parameters:
[
  13
]
6 0.25 ms
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 = ?
Parameters:
[
  8
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Product 5
App\Entity\Category 3
App\Entity\Tag 1

Entities Mapping

Class Mapping errors
App\Entity\Category No errors.
App\Entity\Product No errors.
App\Entity\Tag No errors.