No post data.
No querystring data.
Query | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`nameseo`, `Category`.`alias`, `Category`.`created`, `Category`.`modified`, `Category`.`status`, `Category`.`order`, `Category`.`image`, `Category`.`level`, `Category`.`display`, `Category`.`code`, `Category`.`content`, `Category`.`meta_key`, `Category`.`meta_des`, `Category`.`hot`, `Category`.`chucnang` FROM `dogophugia_data`.`categories` AS `Category` WHERE `Category`.`id` = '117-ban-trang-diem' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Product`.`id`, `Product`.`title`, `Product`.`title_seo`, `Product`.`alias`, `Product`.`category_id`, `Product`.`category_id2`, `Product`.`view`, `Product`.`content`, `Product`.`msp`, `Product`.`created`, `Product`.`status`, `Product`.`price`, `Product`.`hot`, `Product`.`meta_key`, `Product`.`meta_key_alias`, `Product`.`meta_des`, `Product`.`image1`, `Product`.`image2`, `Product`.`image3`, `Product`.`image4`, `Product`.`image5`, `Product`.`image6`, `Product`.`image1_thumb`, `Product`.`image2_thumb`, `Product`.`image3_thumb`, `Product`.`image4_thumb`, `Product`.`image5_thumb`, `Product`.`image6_thumb`, `Product`.`introduction`, `Product`.`modified`, `Product`.`order` FROM `dogophugia_data`.`products` AS `Product` WHERE `Product`.`status` = 1 AND `Product`.`category_id` = 117 ORDER BY `Product`.`id` DESC | 25 | 25 | 6 | maybe slow |
SELECT `Product`.`id`, `Product`.`title`, `Product`.`title_seo`, `Product`.`alias`, `Product`.`category_id`, `Product`.`category_id2`, `Product`.`view`, `Product`.`content`, `Product`.`msp`, `Product`.`created`, `Product`.`status`, `Product`.`price`, `Product`.`hot`, `Product`.`meta_key`, `Product`.`meta_key_alias`, `Product`.`meta_des`, `Product`.`image1`, `Product`.`image2`, `Product`.`image3`, `Product`.`image4`, `Product`.`image5`, `Product`.`image6`, `Product`.`image1_thumb`, `Product`.`image2_thumb`, `Product`.`image3_thumb`, `Product`.`image4_thumb`, `Product`.`image5_thumb`, `Product`.`image6_thumb`, `Product`.`introduction`, `Product`.`modified`, `Product`.`order` FROM `dogophugia_data`.`products` AS `Product` WHERE `Product`.`status` = 1 AND `Product`.`category_id` = 117 ORDER BY `Product`.`id` DESC LIMIT 20 | 20 | 20 | 4 | maybe slow |
SELECT COUNT(*) AS `count` FROM `dogophugia_data`.`products` AS `Product` WHERE `Product`.`status` = 1 AND `Product`.`category_id` = 117 | 1 | 1 | 1 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`nameseo`, `Category`.`alias`, `Category`.`created`, `Category`.`modified`, `Category`.`status`, `Category`.`order`, `Category`.`image`, `Category`.`level`, `Category`.`display`, `Category`.`code`, `Category`.`content`, `Category`.`meta_key`, `Category`.`meta_des`, `Category`.`hot`, `Category`.`chucnang` FROM `dogophugia_data`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`level` = 1 AND `Category`.`parent_id` = 85 ORDER BY `Category`.`order` ASC | 6 | 6 | 0 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`nameseo`, `Category`.`alias`, `Category`.`created`, `Category`.`modified`, `Category`.`status`, `Category`.`order`, `Category`.`image`, `Category`.`level`, `Category`.`display`, `Category`.`code`, `Category`.`content`, `Category`.`meta_key`, `Category`.`meta_des`, `Category`.`hot`, `Category`.`chucnang` FROM `dogophugia_data`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`level` = 2 AND `Category`.`parent_id` = 94 ORDER BY `Category`.`order` ASC | 11 | 11 | 0 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`nameseo`, `Category`.`alias`, `Category`.`created`, `Category`.`modified`, `Category`.`status`, `Category`.`order`, `Category`.`image`, `Category`.`level`, `Category`.`display`, `Category`.`code`, `Category`.`content`, `Category`.`meta_key`, `Category`.`meta_des`, `Category`.`hot`, `Category`.`chucnang` FROM `dogophugia_data`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`level` = 2 AND `Category`.`parent_id` = 95 ORDER BY `Category`.`order` ASC | 6 | 6 | 0 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`nameseo`, `Category`.`alias`, `Category`.`created`, `Category`.`modified`, `Category`.`status`, `Category`.`order`, `Category`.`image`, `Category`.`level`, `Category`.`display`, `Category`.`code`, `Category`.`content`, `Category`.`meta_key`, `Category`.`meta_des`, `Category`.`hot`, `Category`.`chucnang` FROM `dogophugia_data`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`level` = 2 AND `Category`.`parent_id` = 96 ORDER BY `Category`.`order` ASC | 5 | 5 | 0 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`nameseo`, `Category`.`alias`, `Category`.`created`, `Category`.`modified`, `Category`.`status`, `Category`.`order`, `Category`.`image`, `Category`.`level`, `Category`.`display`, `Category`.`code`, `Category`.`content`, `Category`.`meta_key`, `Category`.`meta_des`, `Category`.`hot`, `Category`.`chucnang` FROM `dogophugia_data`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`level` = 2 AND `Category`.`parent_id` = 97 ORDER BY `Category`.`order` ASC | 1 | 1 | 3 | maybe slow |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`nameseo`, `Category`.`alias`, `Category`.`created`, `Category`.`modified`, `Category`.`status`, `Category`.`order`, `Category`.`image`, `Category`.`level`, `Category`.`display`, `Category`.`code`, `Category`.`content`, `Category`.`meta_key`, `Category`.`meta_des`, `Category`.`hot`, `Category`.`chucnang` FROM `dogophugia_data`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`level` = 2 AND `Category`.`parent_id` = 98 ORDER BY `Category`.`order` ASC | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`nameseo`, `Category`.`alias`, `Category`.`created`, `Category`.`modified`, `Category`.`status`, `Category`.`order`, `Category`.`image`, `Category`.`level`, `Category`.`display`, `Category`.`code`, `Category`.`content`, `Category`.`meta_key`, `Category`.`meta_des`, `Category`.`hot`, `Category`.`chucnang` FROM `dogophugia_data`.`categories` AS `Category` WHERE `Category`.`status` = 1 AND `Category`.`level` = 2 AND `Category`.`parent_id` = 101 ORDER BY `Category`.`order` ASC | 5 | 5 | 0 | |
SELECT `Setting`.`id`, `Setting`.`footer`, `Setting`.`contac`, `Setting`.`email`, `Setting`.`facebook`, `Setting`.`title`, `Setting`.`meta_key`, `Setting`.`meta_des`, `Setting`.`logo`, `Setting`.`maps`, `Setting`.`slogan`, `Setting`.`hethong`, `Setting`.`hotline`, `Setting`.`pass`, `Setting`.`youtube` FROM `dogophugia_data`.`settings` AS `Setting` WHERE `Setting`.`id` = 99 LIMIT 1 | 1 | 1 | 0 | |
SELECT `News`.`id`, `News`.`user_id`, `News`.`title`, `News`.`alias`, `News`.`content`, `News`.`introduction`, `News`.`category_id`, `News`.`category_id1`, `News`.`view`, `News`.`created`, `News`.`status`, `News`.`modified`, `News`.`tag`, `News`.`meta_des`, `News`.`image`, `News`.`image_thumb`, `News`.`order`, `News`.`hot` FROM `dogophugia_data`.`news` AS `News` WHERE `News`.`status` = 1 AND `News`.`hot` = 1 ORDER BY `News`.`order` DESC | 10 | 10 | 0 | |
SELECT `News`.`id`, `News`.`user_id`, `News`.`title`, `News`.`alias`, `News`.`content`, `News`.`introduction`, `News`.`category_id`, `News`.`category_id1`, `News`.`view`, `News`.`created`, `News`.`status`, `News`.`modified`, `News`.`tag`, `News`.`meta_des`, `News`.`image`, `News`.`image_thumb`, `News`.`order`, `News`.`hot` FROM `dogophugia_data`.`news` AS `News` WHERE `News`.`status` = 1 ORDER BY `News`.`id` DESC LIMIT 10 | 10 | 10 | 0 | |
SELECT `Slide`.`id`, `Slide`.`name`, `Slide`.`images`, `Slide`.`link`, `Slide`.`modified`, `Slide`.`created`, `Slide`.`order`, `Slide`.`status`, `Slide`.`phanloai` FROM `dogophugia_data`.`slides` AS `Slide` WHERE `Slide`.`status` = 1 ORDER BY `Slide`.`order` ASC | 0 | 0 | 0 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`nameseo`, `Category`.`alias`, `Category`.`created`, `Category`.`modified`, `Category`.`status`, `Category`.`order`, `Category`.`image`, `Category`.`level`, `Category`.`display`, `Category`.`code`, `Category`.`content`, `Category`.`meta_key`, `Category`.`meta_des`, `Category`.`hot`, `Category`.`chucnang` FROM `dogophugia_data`.`categories` AS `Category` WHERE `Category`.`id` = 96 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Category`.`id`, `Category`.`parent_id`, `Category`.`lft`, `Category`.`rght`, `Category`.`name`, `Category`.`nameseo`, `Category`.`alias`, `Category`.`created`, `Category`.`modified`, `Category`.`status`, `Category`.`order`, `Category`.`image`, `Category`.`level`, `Category`.`display`, `Category`.`code`, `Category`.`content`, `Category`.`meta_key`, `Category`.`meta_des`, `Category`.`hot`, `Category`.`chucnang` FROM `dogophugia_data`.`categories` AS `Category` WHERE `Category`.`id` = 85 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Setting`.`id`, `Setting`.`footer`, `Setting`.`contac`, `Setting`.`email`, `Setting`.`facebook`, `Setting`.`title`, `Setting`.`meta_key`, `Setting`.`meta_des`, `Setting`.`logo`, `Setting`.`maps`, `Setting`.`slogan`, `Setting`.`hethong`, `Setting`.`hotline`, `Setting`.`pass`, `Setting`.`youtube` FROM `dogophugia_data`.`settings` AS `Setting` WHERE `Setting`.`id` = 99 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Setting`.`id`, `Setting`.`footer`, `Setting`.`contac`, `Setting`.`email`, `Setting`.`facebook`, `Setting`.`title`, `Setting`.`meta_key`, `Setting`.`meta_des`, `Setting`.`logo`, `Setting`.`maps`, `Setting`.`slogan`, `Setting`.`hethong`, `Setting`.`hotline`, `Setting`.`pass`, `Setting`.`youtube` FROM `dogophugia_data`.`settings` AS `Setting` WHERE `Setting`.`id` = 99 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Product`.`meta_key` FROM `dogophugia_data`.`products` AS `Product` WHERE `status` = 1 AND NOT (`meta_key` IS NULL) ORDER BY `id` DESC | 897 | 897 | 0 |
2 duplicate queries run.
Peak Memory Use 7.76 MB
Message | Memory use |
---|---|
Component initialization | 904 KB |
Controller action start | 1000 KB |
Controller render start | 2.32 MB |
Component initialization #2 | 2.69 MB |
Controller action start #2 | 2.70 MB |
Component initialization #3 | 2.79 MB |
Controller action start #3 | 2.79 MB |
Component initialization #4 | 2.89 MB |
Controller action start #4 | 2.90 MB |
Component initialization #5 | 2.98 MB |
Controller action start #5 | 2.98 MB |
Component initialization #6 | 3.06 MB |
Controller action start #6 | 3.07 MB |
Component initialization #7 | 3.14 MB |
Controller action start #7 | 3.15 MB |
Component initialization #8 | 3.22 MB |
Controller action start #8 | 3.22 MB |
Component initialization #9 | 3.30 MB |
Controller action start #9 | 3.31 MB |
Component initialization #10 | 3.41 MB |
Controller action start #10 | 3.42 MB |
Component initialization #11 | 3.65 MB |
Controller action start #11 | 3.66 MB |
Component initialization #12 | 3.95 MB |
Controller action start #12 | 3.96 MB |
Component initialization #13 | 4.03 MB |
Controller action start #13 | 4.03 MB |
Component initialization #14 | 4.11 MB |
Controller action start #14 | 4.11 MB |
Component initialization #15 | 4.26 MB |
Controller action start #15 | 4.26 MB |
Component initialization #16 | 4.37 MB |
Controller action start #16 | 4.37 MB |
Component initialization #17 | 4.45 MB |
Controller action start #17 | 4.45 MB |
View render complete | 4.47 MB |
Total Request Time: 77 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 3.17 | |
Event: Controller.initialize | 0.13 | |
Event: Controller.startup | 0.16 | |
Controller action | 19.57 | |
Event: Controller.beforeRender | 4.50 | |
» Processing toolbar data | 4.38 | |
Rendering View | 34.14 | |
» Event: View.beforeRender | 0.03 | |
» Rendering APP/View/Category/index.ctp | 24.61 | |
» » Rendering APP/View/Elements/slidebar_left.ctp | 21.50 | |
» » » Event: Controller.initialize #2 | 0.11 | |
» » » Event: Controller.startup #2 | 0.10 | |
Controller action #2 | 0.00 | |
» » » » Event: Controller.shutdown | 0.02 | |
» » » » Event: Controller.initialize #3 | 0.09 | |
» » » » Event: Controller.startup #3 | 0.09 | |
Controller action #3 | 0.00 | |
» » » » » Event: Controller.shutdown #2 | 0.02 | |
» » » » » Event: Controller.initialize #4 | 0.13 | |
» » » » » Event: Controller.startup #4 | 0.14 | |
Controller action #4 | 0.00 | |
» » » » » » Event: Controller.shutdown #3 | 0.02 | |
» » » » » » Event: Controller.initialize #5 | 0.09 | |
» » » » » » Event: Controller.startup #5 | 0.10 | |
Controller action #5 | 0.00 | |
» » » » » » » Event: Controller.shutdown #4 | 0.02 | |
» » » » » » » Event: Controller.initialize #6 | 0.11 | |
» » » » » » » Event: Controller.startup #6 | 0.12 | |
Controller action #6 | 0.00 | |
» » » » » » » » Event: Controller.shutdown #5 | 0.04 | |
» » » » » » » » Event: Controller.initialize #7 | 0.13 | |
» » » » » » » » Event: Controller.startup #7 | 0.14 | |
Controller action #7 | 0.00 | |
» » » » » » » » » Event: Controller.shutdown #6 | 0.02 | |
» » » » » » » » » Event: Controller.initialize #8 | 0.09 | |
» » » » » » » » » Event: Controller.startup #8 | 0.10 | |
Controller action #8 | 0.00 | |
» » » » » » » » » » Event: Controller.shutdown #7 | 0.02 | |
» » » » » » » » » » Event: Controller.initialize #9 | 0.09 | |
» » » » » » » » » » Event: Controller.startup #9 | 0.12 | |
Controller action #9 | 0.00 | |
» » » » » » » » » » » Event: Controller.shutdown #8 | 0.02 | |
» » » » » » » » » » » Event: Controller.initialize #10 | 0.10 | |
» » » » » » » » » » » Event: Controller.startup #10 | 0.12 | |
Controller action #10 | 0.00 | |
» » » » » » » » » » » » Event: Controller.shutdown #9 | 0.02 | |
» » » » » » » » » » » » Event: Controller.initialize #11 | 0.11 | |
» » » » » » » » » » » » Event: Controller.startup #11 | 0.10 | |
Controller action #11 | 0.00 | |
» » » » » » » » » » » » » Event: Controller.shutdown #10 | 0.02 | |
» » » » » » » » » » » » » Event: Controller.initialize #12 | 0.09 | |
» » » » » » » » » » » » » Event: Controller.startup #12 | 0.10 | |
Controller action #12 | 0.00 | |
» » » » » » » » » » » » » » Event: Controller.shutdown #11 | 0.02 | |
» » » » » » » » » » » » » Event: Controller.initialize #13 | 0.09 | |
» » » » » » » » » » » » » Event: Controller.startup #13 | 0.10 | |
Controller action #13 | 0.00 | |
» » » » » » » » » » » » » » Event: Controller.shutdown #12 | 0.02 | |
» » » » » » » » » » » » » » Event: Controller.initialize #14 | 0.13 | |
» » » » » » » » » » » » » » Event: Controller.startup #14 | 0.10 | |
Controller action #14 | 0.00 | |
» » » » » » » » » » » » » » » Event: Controller.shutdown #13 | 0.02 | |
» » » » » » » » » » » » » » » Rendering APP/View/Elements/pagination.ctp | 0.83 | |
» » » » » » » » » » » » » » Event: View.afterRender | 0.02 | |
» » » » » » » » » » » » » » Event: View.beforeLayout | 0.01 | |
» » » » » » » » » » » » » » Rendering APP/View/Layouts/home.ctp | 9.16 | |
» » » » » » » » » » » » » » » Rendering APP/View/Elements/header.ctp | 0.98 | |
» » » » » » » » » » » » » » » » Event: Controller.initialize #15 | 0.09 | |
» » » » » » » » » » » » » » » » Event: Controller.startup #15 | 0.11 | |
Controller action #15 | 0.00 | |
» » » » » » » » » » » » » » » » » Event: Controller.shutdown #14 | 0.02 | |
» » » » » » » » » » » » » » » » Rendering APP/View/Elements/footer.ctp | 7.80 | |
» » » » » » » » » » » » » » » » » Event: Controller.initialize #16 | 0.11 | |
» » » » » » » » » » » » » » » » » Event: Controller.startup #16 | 0.13 | |
Controller action #16 | 0.00 | |
» » » » » » » » » » » » » » » » » » Event: Controller.shutdown #15 | 0.02 | |
» » » » » » » » » » » » » » » » » » Event: Controller.initialize #17 | 0.11 | |
» » » » » » » » » » » » » » » » » » Event: Controller.startup #17 | 0.12 | |
Controller action #17 | 0.00 | |
» » » » » » » » » » » » » » » » » » » Event: Controller.shutdown #16 | 0.02 | |
Event: View.afterLayout | 0.00 |