https://www.dev.mazykkavinyles.fr/vinyles/occasions

Query Metrics

14 Database Queries
8 Different statements
5.82 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.82 ms
SELECT t1.id AS id_2, t1.ref AS ref_3, t1.designation AS designation_4, t1.created_at AS created_at_5, t1.price AS price_6, t1.updated_at AS updated_at_7, t1.promo AS promo_8, t1.description AS description_9, t1.slug AS slug_10, t1.quantity AS quantity_11, t1.weight AS weight_12, t0.format AS format_13, t0.year AS year_14, t0.state AS state_15, t0.img AS img_16, t0.nb_items AS nb_items_17, t1.category_id AS category_id_18, t0.label_id AS label_id_19, t1.category FROM vinyl t0 INNER JOIN product t1 ON t0.id = t1.id WHERE t0.state = ? ORDER BY t1.created_at DESC
Parameters:
[
  "occasion"
]
2 0.38 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:
[]
3 0.31 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:
[]
4 0.33 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:
[]
5 0.52 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:
[]
6 0.68 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:
[]
7 0.39 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:
[
  226
]
8 0.38 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:
[
  226
]
9 0.38 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:
[
  225
]
10 0.33 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:
[
  225
]
11 0.35 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:
[
  224
]
12 0.30 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:
[
  224
]
13 0.34 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:
[
  223
]
14 0.30 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:
[
  223
]

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