0.46 ms (21.99%)
1
SELECT count (DISTINCT b0_ . id ) AS sclr_0 FROM blog_post b0_ WHERE b0_ . published = ? AND EXISTS (SELECT 1 FROM blog_post_blog_tag b1_ WHERE b1_ . blog_post_id = b0_ . id AND b1_ . blog_tag_id IN (? ))
SELECT count (DISTINCT b0_ . id ) AS sclr_0 FROM blog_post b0_ WHERE b0_ . published = 1 AND EXISTS (SELECT 1 FROM blog_post_blog_tag b1_ WHERE b1_ . blog_post_id = b0_ . id AND b1_ . blog_tag_id IN ('d9f8dc6f-8a3a-4863-9c63-8d9ce03fd14c' ));
Copy
0.38 ms (18.21%)
1
SELECT t0 . id AS id_1 , t0 . tag AS tag_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 FROM blog_tag t0
SELECT t0 . id AS id_1 , t0 . tag AS tag_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 FROM blog_tag t0 ;
Copy
0.37 ms (17.81%)
1
SELECT c0_ . id AS id_0 , c0_ . position AS position_1 , c0_ . name AS name_2 , c0_ . active AS active_3 , c0_ . slug AS slug_4 , c0_ . promoted AS promoted_5 , c0_ . image_path AS image_path_6 , c0_ . active_product_count AS active_product_count_7 , c0_ . created_at AS created_at_8 , c0_ . updated_at AS updated_at_9 , c0_ . parent_id AS parent_id_10 FROM category c0_ WHERE c0_ . parent_id IS NULL AND c0_ . active = ? ORDER BY c0_ . position ASC
SELECT c0_ . id AS id_0 , c0_ . position AS position_1 , c0_ . name AS name_2 , c0_ . active AS active_3 , c0_ . slug AS slug_4 , c0_ . promoted AS promoted_5 , c0_ . image_path AS image_path_6 , c0_ . active_product_count AS active_product_count_7 , c0_ . created_at AS created_at_8 , c0_ . updated_at AS updated_at_9 , c0_ . parent_id AS parent_id_10 FROM category c0_ WHERE c0_ . parent_id IS NULL AND c0_ . active = 1 ORDER BY c0_ . position ASC ;
Copy
0.34 ms (16.28%)
1
SELECT t0 . id AS id_1 , t0 . tag AS tag_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 FROM blog_tag t0 WHERE t0 . tag = ? LIMIT 1
SELECT t0 . id AS id_1 , t0 . tag AS tag_2 , t0 . created_at AS created_at_3 , t0 . updated_at AS updated_at_4 FROM blog_tag t0 WHERE t0 . tag = 'owoce' LIMIT 1 ;
Copy
0.30 ms (14.15%)
1
SELECT b0_ . id AS id_0 , b0_ . name AS name_1 , b0_ . content AS content_2 , b0_ . meta_keywords AS meta_keywords_3 , b0_ . meta_description AS meta_description_4 , b0_ . image_path AS image_path_5 , b0_ . slug AS slug_6 , b0_ . published AS published_7 , b0_ . published_at AS published_at_8 , b0_ . created_at AS created_at_9 , b0_ . updated_at AS updated_at_10 , b0_ . supplier_id AS supplier_id_11 FROM blog_post b0_ WHERE b0_ . published = ? AND EXISTS (SELECT 1 FROM blog_post_blog_tag b1_ WHERE b1_ . blog_post_id = b0_ . id AND b1_ . blog_tag_id IN (? )) AND b0_ . id IN (? ) ORDER BY b0_ . published_at DESC
SELECT b0_ . id AS id_0 , b0_ . name AS name_1 , b0_ . content AS content_2 , b0_ . meta_keywords AS meta_keywords_3 , b0_ . meta_description AS meta_description_4 , b0_ . image_path AS image_path_5 , b0_ . slug AS slug_6 , b0_ . published AS published_7 , b0_ . published_at AS published_at_8 , b0_ . created_at AS created_at_9 , b0_ . updated_at AS updated_at_10 , b0_ . supplier_id AS supplier_id_11 FROM blog_post b0_ WHERE b0_ . published = 1 AND EXISTS (SELECT 1 FROM blog_post_blog_tag b1_ WHERE b1_ . blog_post_id = b0_ . id AND b1_ . blog_tag_id IN ('d9f8dc6f-8a3a-4863-9c63-8d9ce03fd14c' )) AND b0_ . id IN ('d2e8a691-52b7-4d82-98e9-e9ec98a7e179' ) ORDER BY b0_ . published_at DESC ;
Copy
0.24 ms (11.56%)
1
SELECT DISTINCT b0_ . id AS id_0 , b0_ . published_at AS published_at_1 FROM blog_post b0_ WHERE b0_ . published = ? AND EXISTS (SELECT 1 FROM blog_post_blog_tag b1_ WHERE b1_ . blog_post_id = b0_ . id AND b1_ . blog_tag_id IN (? )) ORDER BY b0_ . published_at DESC LIMIT 10
SELECT DISTINCT b0_ . id AS id_0 , b0_ . published_at AS published_at_1 FROM blog_post b0_ WHERE b0_ . published = 1 AND EXISTS (SELECT 1 FROM blog_post_blog_tag b1_ WHERE b1_ . blog_post_id = b0_ . id AND b1_ . blog_tag_id IN ('d9f8dc6f-8a3a-4863-9c63-8d9ce03fd14c' )) ORDER BY b0_ . published_at DESC LIMIT 10 ;
Copy