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

Query Metrics

47 Database Queries
8 Different statements
28.77 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
22.46 ms
(78.06%)
40
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
]
1.73 ms
(6.00%)
1
SELECT 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, s2_.id AS id_16, s2_.name AS name_17, s2_.slug AS slug_18, p0_.category AS category_19, p0_.category_id AS category_id_20, v1_.label_id AS label_id_21 FROM vinyl v1_ INNER JOIN product p0_ ON v1_.id = p0_.id LEFT JOIN vinyl_style v3_ ON v1_.id = v3_.vinyl_id LEFT JOIN style s2_ ON s2_.id = v3_.style_id WHERE s2_.id = ? ORDER BY p0_.created_at DESC, s2_.name ASC
Parameters:
[
  22
]
1.34 ms
(4.65%)
1
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:
[]
0.89 ms
(3.08%)
1
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:
[]
0.77 ms
(2.68%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM style t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "freetekno"
]
0.64 ms
(2.21%)
1
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:
[]
0.51 ms
(1.76%)
1
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:
[]
0.45 ms
(1.57%)
1
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:
[]

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