1
2.04 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . display_name AS display_name_3 , t0 . slug AS slug_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . image_name AS image_name_7 , t0 . title AS title_8 , t0 . cat_desc AS cat_desc_9 , t0 . seo_desc AS seo_desc_10 , t0 . seo_title AS seo_title_11 , t0 . desc_title AS desc_title_12 , t0 . keywords AS keywords_13 , t0 . has_child AS has_child_14 , t0 . video_count AS video_count_15 , t0 . parent_id AS parent_id_16 FROM vid_category t0 WHERE t0 . slug = ? LIMIT 1
Parameters :
[
"funny-status "
]
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . display_name AS display_name_3 , t0 . slug AS slug_4 , t0 . created_at AS created_at_5 , t0 . updated_at AS updated_at_6 , t0 . image_name AS image_name_7 , t0 . title AS title_8 , t0 . cat_desc AS cat_desc_9 , t0 . seo_desc AS seo_desc_10 , t0 . seo_title AS seo_title_11 , t0 . desc_title AS desc_title_12 , t0 . keywords AS keywords_13 , t0 . has_child AS has_child_14 , t0 . video_count AS video_count_15 , t0 . parent_id AS parent_id_16 FROM vid_category t0 WHERE t0 . slug = 'funny-status' LIMIT 1 ;
Copy
2
3.95 ms
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 vid_category v1_ ON v0_ . category = v1_ . id LEFT JOIN vid_category v2_ ON v0_ . subCategory = v2_ . id WHERE (v1_ . slug = ? OR v2_ . slug = ? ) AND v0_ . status = 1 ORDER BY v0_ . id DESC
Parameters :
[
"funny-status "
"funny-status "
]
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 vid_category v1_ ON v0_ . category = v1_ . id LEFT JOIN vid_category v2_ ON v0_ . subCategory = v2_ . id WHERE (v1_ . slug = 'funny-status' OR v2_ . slug = 'funny-status' ) AND v0_ . status = 1 ORDER BY v0_ . id DESC ;
Copy
3
1.75 ms
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 :
[
66
"cat "
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 = 66 AND c0_ . type = 'cat' 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
4
1.18 ms
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
5
0.61 ms
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
6
0.59 ms
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
7
0.40 ms
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