1
0.34 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 ;
Copy
2
0.25 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 ;
Copy
3
0.69 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/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 = '/tablatures/catalogue' ORDER BY b1_ . position ASC ;
Copy
4
0.26 ms
SELECT count (DISTINCT t0_ . id ) AS sclr_0 FROM tablature t0_ WHERE t0_ . is_published = ?
SELECT count (DISTINCT t0_ . id ) AS sclr_0 FROM tablature t0_ WHERE t0_ . is_published = 1 ;
Copy
5
0.22 ms
SELECT DISTINCT t0_ . id AS id_0 , t0_ . created_at AS created_at_1 FROM tablature t0_ WHERE t0_ . is_published = ? ORDER BY t0_ . created_at DESC LIMIT 12
SELECT DISTINCT t0_ . id AS id_0 , t0_ . created_at AS created_at_1 FROM tablature t0_ WHERE t0_ . is_published = 1 ORDER BY t0_ . created_at DESC LIMIT 12 ;
Copy
6
0.25 ms
SELECT t0_ . id AS id_0 , t0_ . title AS title_1 , t0_ . slug AS slug_2 , t0_ . description AS description_3 , t0_ . tab_key AS tab_key_4 , t0_ . difficulty AS difficulty_5 , t0_ . pdf AS pdf_6 , t0_ . image AS image_7 , t0_ . is_published AS is_published_8 , t0_ . created_at AS created_at_9 , t0_ . updated_at AS updated_at_10 , t0_ . is_capo AS is_capo_11 FROM tablature t0_ WHERE t0_ . is_published = ? AND t0_ . id IN (? ) ORDER BY t0_ . created_at DESC
SELECT t0_ . id AS id_0 , t0_ . title AS title_1 , t0_ . slug AS slug_2 , t0_ . description AS description_3 , t0_ . tab_key AS tab_key_4 , t0_ . difficulty AS difficulty_5 , t0_ . pdf AS pdf_6 , t0_ . image AS image_7 , t0_ . is_published AS is_published_8 , t0_ . created_at AS created_at_9 , t0_ . updated_at AS updated_at_10 , t0_ . is_capo AS is_capo_11 FROM tablature t0_ WHERE t0_ . is_published = 1 AND t0_ . id IN (1 ) ORDER BY t0_ . created_at DESC ;
Copy
7
0.33 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 ;
Copy