1.65 ms (32.96%)
5
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . css_class AS css_class_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM article_category t0 INNER JOIN article_article_category ON t0 . id = article_article_category . article_category_id WHERE article_article_category . article_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . css_class AS css_class_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 FROM article_category t0 INNER JOIN article_article_category ON t0 . id = article_article_category . article_category_id WHERE article_article_category . article_id = 5 ;
Copy
1.18 ms (23.49%)
5
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 , t0 . article_id AS article_id_5 FROM article_image t0 WHERE t0 . article_id = ?
SELECT t0 . id AS id_1 , t0 . image AS image_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 , t0 . article_id AS article_id_5 FROM article_image t0 WHERE t0 . article_id = 5 ;
Copy
0.62 ms (12.31%)
1
SELECT count (DISTINCT a0_ . id ) AS sclr_0 FROM article a0_ WHERE a0_ . is_published = 1
SELECT count (DISTINCT a0_ . id ) AS sclr_0 FROM article a0_ WHERE a0_ . is_published = 1 ;
Copy
0.58 ms (11.66%)
1
SELECT h0_ . id AS id_0 , h0_ . title AS title_1 , h0_ . subtitle AS subtitle_2 , h0_ . description AS description_3 , h0_ . image AS image_4 , h0_ . button_label AS button_label_5 , h0_ . button_url AS button_url_6 , h0_ . priority AS priority_7 , h0_ . is_active AS is_active_8 , h0_ . created_at AS created_at_9 , h0_ . updated_at AS updated_at_10 FROM home_slide h0_ WHERE h0_ . is_active = ? ORDER BY h0_ . priority ASC , h0_ . created_at ASC
SELECT h0_ . id AS id_0 , h0_ . title AS title_1 , h0_ . subtitle AS subtitle_2 , h0_ . description AS description_3 , h0_ . image AS image_4 , h0_ . button_label AS button_label_5 , h0_ . button_url AS button_url_6 , h0_ . priority AS priority_7 , h0_ . is_active AS is_active_8 , h0_ . created_at AS created_at_9 , h0_ . updated_at AS updated_at_10 FROM home_slide h0_ WHERE h0_ . is_active = 1 ORDER BY h0_ . priority ASC , h0_ . created_at ASC ;
Copy
0.44 ms (8.68%)
1
SELECT s0_ . id AS id_0 , s0_ . name AS name_1 , s0_ . logo AS logo_2 , s0_ . url AS url_3 , s0_ . priority AS priority_4 , s0_ . is_active AS is_active_5 , s0_ . created_at AS created_at_6 , s0_ . updated_at AS updated_at_7 FROM sponsor s0_ WHERE s0_ . is_active = 1 ORDER BY s0_ . priority ASC , s0_ . created_at ASC
SELECT s0_ . id AS id_0 , s0_ . name AS name_1 , s0_ . logo AS logo_2 , s0_ . url AS url_3 , s0_ . priority AS priority_4 , s0_ . is_active AS is_active_5 , s0_ . created_at AS created_at_6 , s0_ . updated_at AS updated_at_7 FROM sponsor s0_ WHERE s0_ . is_active = 1 ORDER BY s0_ . priority ASC , s0_ . created_at ASC ;
Copy
0.32 ms (6.37%)
1
SELECT a0_ . id AS id_0 , a0_ . title AS title_1 , a0_ . slug AS slug_2 , a0_ . excerpt AS excerpt_3 , a0_ . content AS content_4 , a0_ . published_at AS published_at_5 , a0_ . is_published AS is_published_6 , a0_ . created_at AS created_at_7 , a0_ . updated_at AS updated_at_8 FROM article a0_ WHERE a0_ . is_published = 1 AND a0_ . id IN (? , ? , ? , ? , ? ) ORDER BY a0_ . published_at DESC
Parameters :
[
5
4
3
2
1
]
SELECT a0_ . id AS id_0 , a0_ . title AS title_1 , a0_ . slug AS slug_2 , a0_ . excerpt AS excerpt_3 , a0_ . content AS content_4 , a0_ . published_at AS published_at_5 , a0_ . is_published AS is_published_6 , a0_ . created_at AS created_at_7 , a0_ . updated_at AS updated_at_8 FROM article a0_ WHERE a0_ . is_published = 1 AND a0_ . id IN (5 , 4 , 3 , 2 , 1 ) ORDER BY a0_ . published_at DESC ;
Copy
0.23 ms (4.53%)
1
SELECT DISTINCT a0_ . id AS id_0 , a0_ . published_at AS published_at_1 FROM article a0_ WHERE a0_ . is_published = 1 ORDER BY a0_ . published_at DESC LIMIT 6 OFFSET 6
SELECT DISTINCT a0_ . id AS id_0 , a0_ . published_at AS published_at_1 FROM article a0_ WHERE a0_ . is_published = 1 ORDER BY a0_ . published_at DESC LIMIT 6 OFFSET 6 ;
Copy