https://www.dev.mazykkavinyles.fr/vinyles/search?label=199

Query Metrics

21 Database Queries
9 Different statements
14.62 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.91 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2 FROM style s0_ ORDER BY s0_.name ASC
Parameters:
[]
2 0.55 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.slug AS slug_2 FROM label l0_ WHERE l0_.id IN (?) ORDER BY l0_.name ASC
Parameters:
[
  "199"
]
3 1.76 ms
SELECT DISTINCT p0_.id AS id_0, p0_.ref AS ref_1, p0_.designation AS designation_2, p0_.created_at AS created_at_3, p0_.price AS price_4, p0_.updated_at AS updated_at_5, p0_.promo AS promo_6, p0_.description AS description_7, p0_.slug AS slug_8, p0_.quantity AS quantity_9, p0_.weight AS weight_10, v1_.format AS format_11, v1_.year AS year_12, v1_.state AS state_13, v1_.img AS img_14, v1_.nb_items AS nb_items_15, p0_.category AS category_16, p0_.category_id AS category_id_17, v1_.label_id AS label_id_18 FROM vinyl v1_ INNER JOIN product p0_ ON v1_.id = p0_.id LEFT JOIN label l2_ ON v1_.label_id = l2_.id LEFT JOIN track t3_ ON v1_.id = t3_.vinyl_id LEFT JOIN track_artist t5_ ON t3_.id = t5_.track_id LEFT JOIN artist a4_ ON a4_.id = t5_.artist_id WHERE v1_.label_id = ? ORDER BY p0_.created_at DESC
Parameters:
[
  199
]
4 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.start_at AS start_at_4, t0.end_at AS end_at_5 FROM params t0
Parameters:
[]
5 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM style t0 ORDER BY t0.name ASC
Parameters:
[]
6 0.86 ms
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.slug AS slug_2 FROM label l0_ ORDER BY l0_.name ASC
Parameters:
[]
7 1.39 ms
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2 FROM artist a0_ ORDER BY a0_.name ASC
Parameters:
[]
8 0.80 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM style t0 INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id WHERE vinyl_style.vinyl_id = ? ORDER BY t0.name ASC
Parameters:
[
  220
]
9 0.67 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.piste AS piste_3, t0.title AS title_4, t0.vinyl_id AS vinyl_id_5 FROM track t0 WHERE t0.vinyl_id = ?
Parameters:
[
  220
]
10 0.56 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM style t0 INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id WHERE vinyl_style.vinyl_id = ? ORDER BY t0.name ASC
Parameters:
[
  219
]
11 0.48 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.piste AS piste_3, t0.title AS title_4, t0.vinyl_id AS vinyl_id_5 FROM track t0 WHERE t0.vinyl_id = ?
Parameters:
[
  219
]
12 0.52 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM style t0 INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id WHERE vinyl_style.vinyl_id = ? ORDER BY t0.name ASC
Parameters:
[
  218
]
13 0.94 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.piste AS piste_3, t0.title AS title_4, t0.vinyl_id AS vinyl_id_5 FROM track t0 WHERE t0.vinyl_id = ?
Parameters:
[
  218
]
14 0.53 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM style t0 INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id WHERE vinyl_style.vinyl_id = ? ORDER BY t0.name ASC
Parameters:
[
  217
]
15 0.45 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.piste AS piste_3, t0.title AS title_4, t0.vinyl_id AS vinyl_id_5 FROM track t0 WHERE t0.vinyl_id = ?
Parameters:
[
  217
]
16 0.52 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM style t0 INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id WHERE vinyl_style.vinyl_id = ? ORDER BY t0.name ASC
Parameters:
[
  216
]
17 0.50 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.piste AS piste_3, t0.title AS title_4, t0.vinyl_id AS vinyl_id_5 FROM track t0 WHERE t0.vinyl_id = ?
Parameters:
[
  216
]
18 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM style t0 INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id WHERE vinyl_style.vinyl_id = ? ORDER BY t0.name ASC
Parameters:
[
  215
]
19 0.50 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.piste AS piste_3, t0.title AS title_4, t0.vinyl_id AS vinyl_id_5 FROM track t0 WHERE t0.vinyl_id = ?
Parameters:
[
  215
]
20 0.55 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM style t0 INNER JOIN vinyl_style ON t0.id = vinyl_style.style_id WHERE vinyl_style.vinyl_id = ? ORDER BY t0.name ASC
Parameters:
[
  63
]
21 0.49 ms
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.piste AS piste_3, t0.title AS title_4, t0.vinyl_id AS vinyl_id_5 FROM track t0 WHERE t0.vinyl_id = ?
Parameters:
[
  63
]

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\Style No errors.
App\Entity\Product No errors.
App\Entity\Vinyl No errors.
App\Entity\Cd No errors.
App\Entity\Label No errors.
App\Entity\Artist No errors.
App\Entity\Track No errors.
App\Entity\Category No errors.
App\Entity\Promote No errors.
App\Entity\Detail No errors.
App\Entity\Params No errors.