9.64 ms (48.92%)
1
SELECT v0_ . id AS id_0 , v0_ . title AS title_1 , v0_ . picture AS picture_2 , v0_ . slug AS slug_3 , v0_ . file_size AS file_size_4 , v0_ . total_view AS total_view_5 , v0_ . duration AS duration_6 , v0_ . slug AS slug_7 , v1_ . id AS id_8 , v1_ . name AS name_9 , v1_ . slug AS slug_10 FROM video v0_ LEFT JOIN vid_category v1_ ON v0_ . category = v1_ . id WHERE v0_ . status = 1 ORDER BY v0_ . id DESC LIMIT 5
SELECT v0_ . id AS id_0 , v0_ . title AS title_1 , v0_ . picture AS picture_2 , v0_ . slug AS slug_3 , v0_ . file_size AS file_size_4 , v0_ . total_view AS total_view_5 , v0_ . duration AS duration_6 , v0_ . slug AS slug_7 , v1_ . id AS id_8 , v1_ . name AS name_9 , v1_ . slug AS slug_10 FROM video v0_ LEFT JOIN vid_category v1_ ON v0_ . category = v1_ . id WHERE v0_ . status = 1 ORDER BY v0_ . id DESC LIMIT 5 ;
Copy
4.76 ms (24.13%)
1
SELECT s0_ . id AS id_0 , s0_ . name AS name_1 , s0_ . slug AS slug_2 , s0_ . display_name AS display_name_3 , s0_ . image_name AS image_name_4 , s0_ . created_at AS created_at_5 , s0_ . updated_at AS updated_at_6 , s0_ . title AS title_7 , s0_ . cat_desc AS cat_desc_8 , s0_ . seo_title AS seo_title_9 , s0_ . keywords AS keywords_10 , s0_ . seo_desc AS seo_desc_11 , s0_ . desc_title AS desc_title_12 , s0_ . video_count AS video_count_13 FROM singer s0_ WHERE s0_ . video_count > ? ORDER BY s0_ . name ASC LIMIT 5
SELECT s0_ . id AS id_0 , s0_ . name AS name_1 , s0_ . slug AS slug_2 , s0_ . display_name AS display_name_3 , s0_ . image_name AS image_name_4 , s0_ . created_at AS created_at_5 , s0_ . updated_at AS updated_at_6 , s0_ . title AS title_7 , s0_ . cat_desc AS cat_desc_8 , s0_ . seo_title AS seo_title_9 , s0_ . keywords AS keywords_10 , s0_ . seo_desc AS seo_desc_11 , s0_ . desc_title AS desc_title_12 , s0_ . video_count AS video_count_13 FROM singer s0_ WHERE s0_ . video_count > 0 ORDER BY s0_ . name ASC LIMIT 5 ;
Copy
1.69 ms (8.59%)
1
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . display_name AS display_name_4 , t0 . image_name AS image_name_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . title AS title_8 , t0 . cat_desc AS cat_desc_9 , t0 . seo_title AS seo_title_10 , t0 . keywords AS keywords_11 , t0 . seo_desc AS seo_desc_12 , t0 . desc_title AS desc_title_13 , t0 . video_count AS video_count_14 FROM festival t0 WHERE t0 . slug = ? LIMIT 1
Parameters :
[
"krishna-janmashtami "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . slug AS slug_3 , t0 . display_name AS display_name_4 , t0 . image_name AS image_name_5 , t0 . created_at AS created_at_6 , t0 . updated_at AS updated_at_7 , t0 . title AS title_8 , t0 . cat_desc AS cat_desc_9 , t0 . seo_title AS seo_title_10 , t0 . keywords AS keywords_11 , t0 . seo_desc AS seo_desc_12 , t0 . desc_title AS desc_title_13 , t0 . video_count AS video_count_14 FROM festival t0 WHERE t0 . slug = 'krishna-janmashtami' LIMIT 1 ;
Copy
1.41 ms (7.14%)
1
SELECT v0_ . id AS id_0 , v0_ . title AS title_1 , v0_ . description AS description_2 , v0_ . slug AS slug_3 , v0_ . status AS status_4 , v0_ . mime_type AS mime_type_5 , v0_ . file_name AS file_name_6 , v0_ . picture AS picture_7 , v0_ . created_at AS created_at_8 , v0_ . updated_at AS updated_at_9 , v0_ . duration AS duration_10 , v0_ . file_size AS file_size_11 , v0_ . total_view AS total_view_12 , v0_ . total_like AS total_like_13 , v0_ . total_dislike AS total_dislike_14 , v0_ . total_download AS total_download_15 , v0_ . lang_slug AS lang_slug_16 , v0_ . file_path AS file_path_17 FROM video v0_ LEFT JOIN festival f1_ ON v0_ . festival = f1_ . id WHERE f1_ . slug = ? AND v0_ . status = 1 ORDER BY v0_ . id DESC
Parameters :
[
"krishna-janmashtami "
]
SELECT v0_ . id AS id_0 , v0_ . title AS title_1 , v0_ . description AS description_2 , v0_ . slug AS slug_3 , v0_ . status AS status_4 , v0_ . mime_type AS mime_type_5 , v0_ . file_name AS file_name_6 , v0_ . picture AS picture_7 , v0_ . created_at AS created_at_8 , v0_ . updated_at AS updated_at_9 , v0_ . duration AS duration_10 , v0_ . file_size AS file_size_11 , v0_ . total_view AS total_view_12 , v0_ . total_like AS total_like_13 , v0_ . total_dislike AS total_dislike_14 , v0_ . total_download AS total_download_15 , v0_ . lang_slug AS lang_slug_16 , v0_ . file_path AS file_path_17 FROM video v0_ LEFT JOIN festival f1_ ON v0_ . festival = f1_ . id WHERE f1_ . slug = 'krishna-janmashtami' AND v0_ . status = 1 ORDER BY v0_ . id DESC ;
Copy
1.29 ms (6.55%)
1
SELECT c0_ . id AS id_0 , c0_ . comment_at AS comment_at_1 , c0_ . obj_id AS obj_id_2 , c0_ . type AS type_3 , c0_ . website AS website_4 , c0_ . name AS name_5 , c0_ . email AS email_6 , c0_ . comment AS comment_7 , c0_ . ip_address AS ip_address_8 , c0_ . bg_color AS bg_color_9 , c0_ . status AS status_10 , c0_ . parent_id AS parent_id_11 FROM comments c0_ WHERE c0_ . obj_id = ? AND c0_ . type = ? AND c0_ . parent_id IS NULL AND (c0_ . status = ? OR c0_ . ip_address = ? ) ORDER BY c0_ . comment_at DESC
Parameters :
[
19
"festival "
1
"216.73.216.148 "
]
SELECT c0_ . id AS id_0 , c0_ . comment_at AS comment_at_1 , c0_ . obj_id AS obj_id_2 , c0_ . type AS type_3 , c0_ . website AS website_4 , c0_ . name AS name_5 , c0_ . email AS email_6 , c0_ . comment AS comment_7 , c0_ . ip_address AS ip_address_8 , c0_ . bg_color AS bg_color_9 , c0_ . status AS status_10 , c0_ . parent_id AS parent_id_11 FROM comments c0_ WHERE c0_ . obj_id = 19 AND c0_ . type = 'festival' AND c0_ . parent_id IS NULL AND (c0_ . status = 1 OR c0_ . ip_address = '216.73.216.148' ) ORDER BY c0_ . comment_at DESC ;
Copy
0.57 ms (2.91%)
1
SELECT v0_ . id AS id_0 , v0_ . name AS name_1 , v0_ . display_name AS display_name_2 , v0_ . slug AS slug_3 , v0_ . created_at AS created_at_4 , v0_ . updated_at AS updated_at_5 , v0_ . image_name AS image_name_6 , v0_ . title AS title_7 , v0_ . cat_desc AS cat_desc_8 , v0_ . seo_desc AS seo_desc_9 , v0_ . seo_title AS seo_title_10 , v0_ . desc_title AS desc_title_11 , v0_ . keywords AS keywords_12 , v0_ . has_child AS has_child_13 , v0_ . video_count AS video_count_14 FROM vid_category v0_ WHERE v0_ . parent_id IS NULL AND v0_ . video_count > ? ORDER BY v0_ . name ASC LIMIT 5
SELECT v0_ . id AS id_0 , v0_ . name AS name_1 , v0_ . display_name AS display_name_2 , v0_ . slug AS slug_3 , v0_ . created_at AS created_at_4 , v0_ . updated_at AS updated_at_5 , v0_ . image_name AS image_name_6 , v0_ . title AS title_7 , v0_ . cat_desc AS cat_desc_8 , v0_ . seo_desc AS seo_desc_9 , v0_ . seo_title AS seo_title_10 , v0_ . desc_title AS desc_title_11 , v0_ . keywords AS keywords_12 , v0_ . has_child AS has_child_13 , v0_ . video_count AS video_count_14 FROM vid_category v0_ WHERE v0_ . parent_id IS NULL AND v0_ . video_count > 0 ORDER BY v0_ . name ASC LIMIT 5 ;
Copy
0.35 ms (1.76%)
1
SELECT f0_ . id AS id_0 , f0_ . name AS name_1 , f0_ . slug AS slug_2 , f0_ . display_name AS display_name_3 , f0_ . image_name AS image_name_4 , f0_ . created_at AS created_at_5 , f0_ . updated_at AS updated_at_6 , f0_ . title AS title_7 , f0_ . cat_desc AS cat_desc_8 , f0_ . seo_title AS seo_title_9 , f0_ . keywords AS keywords_10 , f0_ . seo_desc AS seo_desc_11 , f0_ . desc_title AS desc_title_12 , f0_ . video_count AS video_count_13 FROM festival f0_ WHERE f0_ . video_count > ? ORDER BY f0_ . name ASC LIMIT 5
SELECT f0_ . id AS id_0 , f0_ . name AS name_1 , f0_ . slug AS slug_2 , f0_ . display_name AS display_name_3 , f0_ . image_name AS image_name_4 , f0_ . created_at AS created_at_5 , f0_ . updated_at AS updated_at_6 , f0_ . title AS title_7 , f0_ . cat_desc AS cat_desc_8 , f0_ . seo_title AS seo_title_9 , f0_ . keywords AS keywords_10 , f0_ . seo_desc AS seo_desc_11 , f0_ . desc_title AS desc_title_12 , f0_ . video_count AS video_count_13 FROM festival f0_ WHERE f0_ . video_count > 0 ORDER BY f0_ . name ASC LIMIT 5 ;
Copy