Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Setting`.* FROM `chophutung_db`.`setting` AS `Setting` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Company`.* FROM `chophutung_db`.`company` AS `Company` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Menu`.*, `ProductCategory`.`slug`, `Page`.`slug`, `BlogCategory`.`slug` FROM `chophutung_db`.`menus` AS `Menu` left JOIN `chophutung_db`.`product_categories` AS `ProductCategory` ON (`Menu`.`type` = "ProductCategory" AND `Menu`.`child` = `ProductCategory`.`id`) left JOIN `chophutung_db`.`blog_categories` AS `BlogCategory` ON (`Menu`.`type` = "BlogCategory" AND `Menu`.`child` = `BlogCategory`.`id`) left JOIN `chophutung_db`.`pages` AS `Page` ON (`Menu`.`type` = "Page" AND `Menu`.`child` = `Page`.`id`) LEFT JOIN `chophutung_db`.`menus` AS `ParentMenu` ON (`Menu`.`parent_id` = `ParentMenu`.`id`) WHERE `Menu`.`active` = '1' ORDER BY `Menu`.`order` asc | 13 | 13 | 1 | maybe slow |
SELECT `Post`.`name_vie`, `Post`.`slug`, `Post`.`footer`, `Post`.`help` FROM `chophutung_db`.`posts` AS `Post` WHERE `Post`.`active` = '1' AND `Post`.`help` = '1' ORDER BY `Post`.`order` asc, `Post`.`created` desc LIMIT 5 | 5 | 5 | 1 | maybe slow |
SELECT `Post`.`name_vie`, `Post`.`slug`, `Post`.`footer`, `Post`.`help` FROM `chophutung_db`.`posts` AS `Post` WHERE `Post`.`active` = '1' AND `Post`.`footer` = '1' ORDER BY `Post`.`order` asc, `Post`.`created` desc LIMIT 5 | 5 | 5 | 1 | maybe slow |
SELECT `Post`.`id`, `Post`.`title`, `Post`.`name_vie`, `Post`.`name_eng`, `Post`.`slug`, `Post`.`description`, `Post`.`keyword`, `Post`.`content_eng`, `Post`.`content_vie`, `Post`.`active`, `Post`.`feature`, `Post`.`left_sidebar`, `Post`.`help`, `Post`.`footer`, `Post`.`canonical`, `Post`.`views`, `Post`.`order`, `Post`.`image`, `Post`.`comment`, `Post`.`blog_category_id`, `Post`.`blog_category_id_2`, `Post`.`blog_category_id_3`, `Post`.`blog_category_id_4`, `Post`.`user_id`, `Post`.`created` FROM `chophutung_db`.`posts` AS `Post` WHERE `Post`.`active` = '1' AND `Post`.`left_sidebar` = '1' AND `Post`.`help` = '0' AND `Post`.`footer` = '0' ORDER BY `Post`.`order` asc, `Post`.`created` desc LIMIT 5 | 5 | 5 | 1 | maybe slow |
SELECT `Product`.`id`, `Product`.`rate`, `Product`.`count_rate`, `Product`.`name_vie`, `Product`.`slug`, `Product`.`price`, `Product`.`price_sale`, `Product`.`created`, `Product`.`image`, `Product`.`image_default` FROM `chophutung_db`.`products` AS `Product` WHERE `active` = '1' AND `sale` = '1' ORDER BY `order` asc, `created` desc LIMIT 5 | 4 | 4 | 5 | maybe slow |
SELECT `Banner`.`id`, `Banner`.`image`, `Banner`.`title`, `Banner`.`caption`, `Banner`.`button_text`, `Banner`.`small_caption`, `Banner`.`url`, `Banner`.`type`, `Banner`.`order`, `Banner`.`active`, `Banner`.`created` FROM `chophutung_db`.`banners` AS `Banner` WHERE `Banner`.`active` = '1' AND `Banner`.`type` = 3 ORDER BY `order` asc, `created` desc LIMIT 4294967295 | 10 | 10 | 0 | |
SELECT `Banner`.`id`, `Banner`.`image`, `Banner`.`title`, `Banner`.`caption`, `Banner`.`button_text`, `Banner`.`small_caption`, `Banner`.`url`, `Banner`.`type`, `Banner`.`order`, `Banner`.`active`, `Banner`.`created` FROM `chophutung_db`.`banners` AS `Banner` WHERE `Banner`.`active` = '1' AND `Banner`.`type` = 2 ORDER BY `order` asc, `created` desc LIMIT 4294967295 | 2 | 2 | 0 | |
SELECT `Support`.`id`, `Support`.`nick_name`, `Support`.`name`, `Support`.`phone`, `Support`.`active`, `Support`.`type`, `Support`.`created` FROM `chophutung_db`.`supports` AS `Support` WHERE `active` = '1' ORDER BY `type` desc | 0 | 0 | 0 | |
SELECT `Post`.`id`, `Post`.`title`, `Post`.`name_vie`, `Post`.`name_eng`, `Post`.`slug`, `Post`.`description`, `Post`.`keyword`, `Post`.`content_eng`, `Post`.`content_vie`, `Post`.`active`, `Post`.`feature`, `Post`.`left_sidebar`, `Post`.`help`, `Post`.`footer`, `Post`.`canonical`, `Post`.`views`, `Post`.`order`, `Post`.`image`, `Post`.`comment`, `Post`.`blog_category_id`, `Post`.`blog_category_id_2`, `Post`.`blog_category_id_3`, `Post`.`blog_category_id_4`, `Post`.`user_id`, `Post`.`created`, `BlogCategory`.`id`, `BlogCategory`.`title`, `BlogCategory`.`name_vie`, `BlogCategory`.`name_eng`, `BlogCategory`.`slug`, `BlogCategory`.`description`, `BlogCategory`.`keyword`, `BlogCategory`.`introduction`, `BlogCategory`.`active`, `BlogCategory`.`order`, `BlogCategory`.`type`, `BlogCategory`.`parent_id`, `BlogCategory`.`rght`, `BlogCategory`.`lft`, `BlogCategory`.`image`, `BlogCategory`.`created`, `User`.`id`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`name`, `User`.`google`, `User`.`image`, `User`.`slogan`, `User`.`role`, `User`.`token`, `User`.`active`, `User`.`created`, (SELECT COUNT(*) FROM posts WHERE `posts`.`user_id` = `User`.`id`) AS `User__countPost`, (SELECT COUNT(*) FROM posts WHERE `posts`.`user_id` = `User`.`id` AND `posts`.`active`=1) AS `User__countPostActive`, (SELECT COUNT(*) FROM posts WHERE `posts`.`user_id` = `User`.`id` AND `posts`.`active`=0) AS `User__countPostInActive`, (SELECT COUNT(*) FROM posts WHERE `posts`.`user_id` = `User`.`id` AND `posts`.`created` >= "2021-04-01 00:00:00") AS `User__countPostInMonth`, (SELECT COUNT(*) FROM posts WHERE `posts`.`user_id` = `User`.`id` AND `posts`.`active`=1 AND `posts`.`created` >= "2021-04-01 00:00:00") AS `User__countPostInMonthActive`, (SELECT COUNT(*) FROM posts WHERE `posts`.`user_id` = `User`.`id` AND `posts`.`created` >= "2021-03-01 00:00:00" AND `posts`.`created` < "2021-04-01 00:00:00") AS `User__countPostInLastMonth`, (SELECT COUNT(*) FROM posts WHERE `posts`.`user_id` = `User`.`id` AND `posts`.`active`=1 AND `posts`.`created` >= "2021-03-01 00:00:00" AND `posts`.`created` < "2021-04-01 00:00:00") AS `User__countPostInLastMonthActive`, (SELECT COUNT(*) FROM comments WHERE `comments`.`old_comment`=0 OR `comments`.`old_comment` IS NULL) AS `User__count_comment`, (SELECT COUNT(*) FROM posts WHERE `posts`.`user_id` = `User`.`id` AND `posts`.`active`=0 AND ( `posts`.`comment` IS NOT NULL AND `posts`.`comment` !='')) AS `User__count_posts_invalid`, (SELECT COUNT(*) FROM posts WHERE `posts`.`active`=0 AND ( `posts`.`comment` IS NOT NULL AND `posts`.`comment` !='')) AS `User__count_posts_invalid_all`, (SELECT COUNT(*) FROM posts WHERE `posts`.`active`=0 AND ( `posts`.`comment` IS NULL OR `posts`.`comment` ="")) AS `User__count_posts_inactive`, (SELECT COUNT(*) FROM posts WHERE `posts`.`user_id` = `User`.`id` AND `posts`.`active`=0 AND ( `posts`.`comment` IS NULL OR `posts`.`comment` ="")) AS `User__count_posts_inactive_user`, (SELECT COUNT(*) FROM posts WHERE `posts`.`active`=0) AS `User__count_posts_inactive_all` FROM `chophutung_db`.`posts` AS `Post` LEFT JOIN `chophutung_db`.`blog_categories` AS `BlogCategory` ON (`Post`.`blog_category_id` = `BlogCategory`.`id`) LEFT JOIN `chophutung_db`.`users` AS `User` ON (`Post`.`user_id` = `User`.`id`) WHERE `Post`.`slug` = 'huong-dan-su-dung-dieu-hoa-o-to-camry-dung-cach' LIMIT 1 | 1 | 1 | 8 | maybe slow |
SELECT `Tag`.`id`, `Tag`.`tag`, `Tag`.`slug`, `Tag`.`description`, `Tag`.`keyword`, `Tag`.`title`, `Tag`.`view`, `Tag`.`order`, `Tag`.`home_page`, `Tag`.`created`, `PostsTag`.`id`, `PostsTag`.`tag_id`, `PostsTag`.`post_id`, `PostsTag`.`created` FROM `chophutung_db`.`tags` AS `Tag` JOIN `chophutung_db`.`posts_tags` AS `PostsTag` ON (`PostsTag`.`post_id` = 378 AND `PostsTag`.`tag_id` = `Tag`.`id`) | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `chophutung_db`.`posts` AS `Post` WHERE `Post`.`id` = 378 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `chophutung_db`.`posts` AS `Post` WHERE `Post`.`id` = 378 | 1 | 1 | 0 | |
UPDATE `chophutung_db`.`posts` SET `views` = 1486 WHERE `chophutung_db`.`posts`.`id` = '378' | 1 | 1 | 30 | maybe slow |
SELECT `Post`.`slug`, `Post`.`image`, `Post`.`created`, `Post`.`name_vie`, `Post`.`content_vie` FROM `chophutung_db`.`posts` AS `Post` WHERE `blog_category_id` = 1 AND `id` != 378 AND `active` = '1' ORDER BY `Post`.`order` asc, `Post`.`created` desc LIMIT 9 | 9 | 9 | 1 | maybe slow |