GET https://mamiejo.com/product/?catalogue=menu-plateaux&category=charcuterie-raclette

Query Metrics

18 Database Queries
7 Different statements
3.14 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.catalogue_id AS catalogue_id_4, t0.image_id AS image_id_5 FROM category t0
Parameters:
[]
2 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_id AS image_id_4 FROM catalogue t0
Parameters:
[]
3 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_id AS image_id_4 FROM catalogue t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "menu-plateaux"
]
4 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.catalogue_id AS catalogue_id_4, t0.image_id AS image_id_5 FROM category t0 WHERE t0.catalogue_id = ? ORDER BY t0.name ASC
Parameters:
[
  4
]
5 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.catalogue_id AS catalogue_id_4, t0.image_id AS image_id_5 FROM category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "charcuterie-raclette"
]
6 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.currency AS currency_4, t0.description AS description_5, t0.slug AS slug_6, t0.title AS title_7, t0.register_date AS register_date_8, t0.specifications AS specifications_9, t0.meta_desc AS meta_desc_10, t0.author_id AS author_id_11, t0.image_id AS image_id_12, t0.category_id AS category_id_13 FROM product t0 WHERE t0.category_id = ? ORDER BY t0.name ASC
Parameters:
[
  30
]
7 0.23 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.alt AS alt_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.product_id AS product_id_6 FROM image t0 WHERE t0.id = ?
Parameters:
[
  11
]
8 0.17 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.alt AS alt_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.product_id AS product_id_6 FROM image t0 WHERE t0.id = ?
Parameters:
[
  12
]
9 0.16 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.alt AS alt_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.product_id AS product_id_6 FROM image t0 WHERE t0.id = ?
Parameters:
[
  13
]
10 0.15 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.alt AS alt_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.product_id AS product_id_6 FROM image t0 WHERE t0.id = ?
Parameters:
[
  14
]
11 0.16 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.alt AS alt_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.product_id AS product_id_6 FROM image t0 WHERE t0.id = ?
Parameters:
[
  15
]
12 0.14 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.alt AS alt_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.product_id AS product_id_6 FROM image t0 WHERE t0.id = ?
Parameters:
[
  16
]
13 0.15 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.alt AS alt_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.product_id AS product_id_6 FROM image t0 WHERE t0.id = ?
Parameters:
[
  25
]
14 0.15 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.alt AS alt_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.product_id AS product_id_6 FROM image t0 WHERE t0.id = ?
Parameters:
[
  75
]
15 0.19 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.alt AS alt_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.product_id AS product_id_6 FROM image t0 WHERE t0.id = ?
Parameters:
[
  73
]
16 0.20 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.alt AS alt_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.product_id AS product_id_6 FROM image t0 WHERE t0.id = ?
Parameters:
[
  72
]
17 0.21 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.alt AS alt_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.product_id AS product_id_6 FROM image t0 WHERE t0.id = ?
Parameters:
[
  76
]
18 0.14 ms
SELECT t0.id AS id_1, t0.url AS url_2, t0.alt AS alt_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.product_id AS product_id_6 FROM image t0 WHERE t0.id = ?
Parameters:
[
  74
]

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\Category No errors.
App\Entity\Catalogue No errors.
App\Entity\Image No errors.
App\Entity\Product No errors.
App\Entity\User No errors.
App\Entity\CartProduct No errors.