| 1 |
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
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;
|
| 2 |
0.56 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: [
"/videos/catalogue"
]
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 = '/videos/catalogue' ORDER BY b1_.position ASC;
|
| 3 |
0.20 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
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;
|
| 4 |
0.23 ms
|
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3 FROM category t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"tutoriel-guitare"
]
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3 FROM category t0 WHERE t0.slug = 'tutoriel-guitare' LIMIT 1;
|
| 5 |
0.43 ms
|
SELECT COUNT(v0_.id) AS sclr_0 FROM video v0_ INNER JOIN category c1_ ON v0_.category_id = c1_.id WHERE v0_.is_published = ? AND v0_.is_short = ? AND c1_.slug = ?
Parameters: [
1
0
"tutoriel-guitare"
]
SELECT COUNT(v0_.id) AS sclr_0 FROM video v0_ INNER JOIN category c1_ ON v0_.category_id = c1_.id WHERE v0_.is_published = 1 AND v0_.is_short = 0 AND c1_.slug = 'tutoriel-guitare';
|
| 6 |
0.23 ms
|
SELECT count(DISTINCT v0_.id) AS sclr_0 FROM video v0_ INNER JOIN category c1_ ON v0_.category_id = c1_.id WHERE v0_.is_published = ? AND v0_.is_short = ? AND c1_.slug = ?
Parameters: [
1
0
"tutoriel-guitare"
]
SELECT count(DISTINCT v0_.id) AS sclr_0 FROM video v0_ INNER JOIN category c1_ ON v0_.category_id = c1_.id WHERE v0_.is_published = 1 AND v0_.is_short = 0 AND c1_.slug = 'tutoriel-guitare';
|
| 7 |
0.29 ms
|
SELECT DISTINCT v0_.id AS id_0, v0_.youtube_published_at AS youtube_published_at_1 FROM video v0_ INNER JOIN category c1_ ON v0_.category_id = c1_.id WHERE v0_.is_published = ? AND v0_.is_short = ? AND c1_.slug = ? ORDER BY v0_.youtube_published_at DESC LIMIT 12
Parameters: [
1
0
"tutoriel-guitare"
]
SELECT DISTINCT v0_.id AS id_0, v0_.youtube_published_at AS youtube_published_at_1 FROM video v0_ INNER JOIN category c1_ ON v0_.category_id = c1_.id WHERE v0_.is_published = 1 AND v0_.is_short = 0 AND c1_.slug = 'tutoriel-guitare' ORDER BY v0_.youtube_published_at DESC LIMIT 12;
|
| 8 |
0.20 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
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;
|