GET https://goldrogerpizzeria.com/menu/post/filter-by-category/36/pizze-classiques

Query Metrics

6 Database Queries
5 Different statements
5.88 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
4.90 ms
(83.23%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.address AS address_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.instagram AS instagram_7, t0.hours AS hours_8, t0.facebook AS facebook_9, t0.user_id AS user_id_10 FROM setting t0
Parameters:
[]
0.31 ms
(5.32%)
2
SELECT t0.id AS id_1, t0.title AS title_2, t0.ingredients AS ingredients_3, t0.price AS price_4, t0.image AS image_5, t0.is_published AS is_published_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.published_at AS published_at_9, t0.category_id AS category_id_10, t0.user_id AS user_id_11 FROM post t0 WHERE t0.category_id = ?
Parameters:
[
  36
]
0.29 ms
(4.98%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM category t0 WHERE t0.id = ?
Parameters:
[
  "36"
]
0.26 ms
(4.40%)
1
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.ingredients AS ingredients_2, p0_.price AS price_3, p0_.image AS image_4, p0_.is_published AS is_published_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7, p0_.published_at AS published_at_8, c1_.id AS id_9, c1_.name AS name_10, c1_.slug AS slug_11, c1_.created_at AS created_at_12, c1_.updated_at AS updated_at_13, p0_.category_id AS category_id_14, p0_.user_id AS user_id_15 FROM post p0_ INNER JOIN category c1_ ON p0_.category_id = c1_.id WHERE c1_.id = ? AND p0_.is_published = 1
Parameters:
[
  "36"
]
0.12 ms
(2.07%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM category t0
Parameters:
[]

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.

Entities Mapping

Class Mapping errors
App\Entity\Setting No errors.
App\Entity\User No errors.
App\Entity\Category No errors.
App\Entity\Post No errors.