Query Metrics
9
Database Queries
7
Different statements
2.96 ms
Query time
0
Invalid entities
12
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.37 ms |
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_email AS site_email_3, t0.site_logo AS site_logo_4, t0.site_url AS site_url_5, t0.site_urlfull AS site_urlfull_6, t0.site_adresse AS site_adresse_7, t0.site_cp AS site_cp_8, t0.site_ville AS site_ville_9, t0.site_phone AS site_phone_10, t0.site_youtube AS site_youtube_11, t0.site_verset AS site_verset_12, t0.site_versetverse AS site_versetverse_13, t0.site_presentation AS site_presentation_14, t0.site_facebook AS site_facebook_15, t0.site_apropos AS site_apropos_16 FROM setting t0 LIMIT 1
Parameters:
[] |
||||||||||||||||||||||||||||
| 2 | 0.27 ms |
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_email AS site_email_3, t0.site_logo AS site_logo_4, t0.site_url AS site_url_5, t0.site_urlfull AS site_urlfull_6, t0.site_adresse AS site_adresse_7, t0.site_cp AS site_cp_8, t0.site_ville AS site_ville_9, t0.site_phone AS site_phone_10, t0.site_youtube AS site_youtube_11, t0.site_verset AS site_verset_12, t0.site_versetverse AS site_versetverse_13, t0.site_presentation AS site_presentation_14, t0.site_facebook AS site_facebook_15, t0.site_apropos AS site_apropos_16 FROM setting t0 LIMIT 1
Parameters:
[]
|
||||||||||||||||||||||||||||
| 3 | 0.37 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4, t0.tab_key AS tab_key_5, t0.difficulty AS difficulty_6, t0.pdf AS pdf_7, t0.image AS image_8, t0.is_published AS is_published_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.is_capo AS is_capo_12 FROM tablature t0 WHERE t0.slug = ? AND t0.is_published = ? LIMIT 1
Parameters:
[ "tu-es-ma-lumiere" 1 ]
|
||||||||||||||||||||||||||||
| 4 | 0.30 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.path AS path_3, p0_.is_published AS is_published_4, b1_.id AS id_5, b1_.type AS type_6, b1_.content AS content_7, b1_.image AS image_8, b1_.section AS section_9, b1_.position AS position_10, b1_.page_id AS page_id_11 FROM page p0_ LEFT JOIN block b1_ ON p0_.id = b1_.page_id WHERE p0_.path = ? ORDER BY b1_.position ASC
Parameters:
[
"/tablatures/tu-es-ma-lumiere"
]
|
||||||||||||||||||||||||||||
| 5 | 0.30 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.tonalite AS tonalite_5, t0.tempo AS tempo_6, t0.duree AS duree_7, t0.mp3 AS mp3_8, t0.image AS image_9, t0.is_published AS is_published_10, t0.is_featured AS is_featured_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.music_style AS music_style_14, t0.video_id AS video_id_15, t0.tablature_id AS tablature_id_16 FROM chant t0 WHERE t0.tablature_id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
| 6 | 0.34 ms |
SELECT t0.id AS id_1, t0.youtube_id AS youtube_id_2, t0.title AS title_3, t0.slug AS slug_4, t0.description AS description_5, t0.excerpt AS excerpt_6, t0.youtube_published_at AS youtube_published_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.duration AS duration_10, t0.is_published AS is_published_11, t0.is_featured AS is_featured_12, t0.video_type AS video_type_13, t0.is_short AS is_short_14, t0.music_style AS music_style_15, t0.thumbnail_url AS thumbnail_url_16, t0.view_count AS view_count_17, t0.category_id AS category_id_18, t0.parent_video_id AS parent_video_id_19, t0.chant_id AS chant_id_20 FROM video t0 WHERE t0.chant_id = ? AND t0.is_short = ? AND t0.is_published = ? ORDER BY t0.youtube_published_at DESC LIMIT 1
Parameters:
[ 2 0 1 ]
|
||||||||||||||||||||||||||||
| 7 | 0.32 ms |
SELECT t0.id AS id_1, t0.youtube_id AS youtube_id_2, t0.title AS title_3, t0.slug AS slug_4, t0.description AS description_5, t0.excerpt AS excerpt_6, t0.youtube_published_at AS youtube_published_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.duration AS duration_10, t0.is_published AS is_published_11, t0.is_featured AS is_featured_12, t0.video_type AS video_type_13, t0.is_short AS is_short_14, t0.music_style AS music_style_15, t0.thumbnail_url AS thumbnail_url_16, t0.view_count AS view_count_17, t0.category_id AS category_id_18, t0.parent_video_id AS parent_video_id_19, t0.chant_id AS chant_id_20 FROM video t0 WHERE t0.chant_id = ? AND t0.is_short = ? AND t0.is_published = ? ORDER BY t0.youtube_published_at DESC
Parameters:
[ 2 1 1 ]
|
||||||||||||||||||||||||||||
| 8 | 0.28 ms |
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_email AS site_email_3, t0.site_logo AS site_logo_4, t0.site_url AS site_url_5, t0.site_urlfull AS site_urlfull_6, t0.site_adresse AS site_adresse_7, t0.site_cp AS site_cp_8, t0.site_ville AS site_ville_9, t0.site_phone AS site_phone_10, t0.site_youtube AS site_youtube_11, t0.site_verset AS site_verset_12, t0.site_versetverse AS site_versetverse_13, t0.site_presentation AS site_presentation_14, t0.site_facebook AS site_facebook_15, t0.site_apropos AS site_apropos_16 FROM setting t0 LIMIT 1
Parameters:
[] |
||||||||||||||||||||||||||||
| 9 | 0.41 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.image AS image_4, t0.description AS description_5, t0.name AS name_6, t0.type AS type_7, t0.family AS family_8, t0.position AS position_9, t0.is_published AS is_published_10 FROM accord t0 INNER JOIN tablature_accord ON t0.id = tablature_accord.accord_id WHERE tablature_accord.tablature_id = ?
Parameters:
[
1
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Video | 4 |
| App\Entity\Accord | 4 |
| App\Entity\Setting | 1 |
| App\Entity\Tablature | 1 |
| App\Entity\Chant | 1 |
| App\Entity\Category | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Setting | No errors. |
| App\Entity\Tablature | No errors. |
| App\Entity\Chant | No errors. |
| App\Entity\Accord | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\Block | No errors. |
| App\Entity\Video | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Newsletter | No errors. |