OK
No post data.
No querystring data.
| Query | Affected | Num. rows | Took (ms) | Actions |
|---|---|---|---|---|
| SELECT `Language`.`id`, `Language`.`alias` FROM `qqrice_test`.`booster_languages` AS `Language` WHERE `Language`.`enabled` = '1' | 3 | 3 | 0 | |
| SELECT `ProductType`.`sorting`, `ProductType`.`slug`, (`ProductTypeLang`.`title`) AS `ProductType__title` FROM `qqrice_test`.`booster_product_types` AS `ProductType` INNER JOIN `qqrice_test`.`booster_product_type_languages` AS `ProductTypeLang` ON (((`ProductTypeLang`.`type_id` = `ProductType`.`id`) AND (`ProductTypeLang`.`alias` = 'zho'))) WHERE `ProductType`.`enabled` = '1' ORDER BY `ProductType`.`sorting` asc | 9 | 9 | 0 | |
| SELECT `Setting`.`slug`, `Setting`.`value` FROM `qqrice_test`.`booster_settings` AS `Setting` WHERE `Setting`.`slug` IN ('social-link-facebook', 'social-link-instagram', 'social-link-youtube', 'social-link-whatsapp', 'social-link-wechat') | 5 | 5 | 0 | |
| SELECT `Product`.`id`, `Product`.`product_number`, `Product`.`channel_type_id`, `Product`.`path`, `Product`.`inventory`, `Product`.`preorder_maximum_inventory`, `Product`.`catering_service_min_qty`, `Product`.`sale_price`, `Product`.`promote_price`, `Product`.`net_weight`, `Product`.`calorie`, `Product`.`path_mascot`, `Product`.`product_type_id`, (`ProductDLang`.`title`) AS `Product__title`, (`ProductDLang`.`origin`) AS `Product__origin`, (`ProductDLang`.`ingredients`) AS `Product__ingredients`, (`ProductDLang`.`preservation`) AS `Product__preservation`, (`ProductDLang`.`nutrition`) AS `Product__nutrition`, (`ProductDLang`.`edible`) AS `Product__edible`, (`ProductDLang`.`description`) AS `Product__description`, (`ProductT`.`slug`) AS `Product__type_slug` FROM `qqrice_test`.`booster_products` AS `Product` INNER JOIN `qqrice_test`.`booster_product_languages` AS `ProductDLang` ON (((`ProductDLang`.`product_id` = `Product`.`id`) AND (`ProductDLang`.`alias` = 'zho'))) INNER JOIN `qqrice_test`.`booster_product_types` AS `ProductT` ON (`ProductT`.`id` = `Product`.`product_type_id`) WHERE `Product`.`enabled` = '1' AND `Product`.`product_number` = 'DS003CN' ORDER BY (`ProductDLang`.`title`) asc LIMIT 1 | 1 | 1 | 1 | |
| SELECT ProductComment.*, Member.name, `ProductComment`.`id` FROM `qqrice_test`.`booster_product_comments` AS `ProductComment` LEFT JOIN `qqrice_test`.`booster_members` AS `Member` ON (`Member`.`id` = `ProductComment`.`member_id`) WHERE `ProductComment`.`product_id` = 13 | 0 | 0 | 0 | |
| SELECT `ProductImage`.`id`, `ProductImage`.`path` FROM `qqrice_test`.`booster_product_images` AS `ProductImage` WHERE `ProductImage`.`product_id` = 13 ORDER BY `ProductImage`.`id` asc | 1 | 1 | 0 | |
| SELECT `Product`.`id`, `Product`.`product_number`, `Product`.`path`, `Product`.`inventory`, `Product`.`sale_price`, `Product`.`promote_price`, `Product`.`net_weight`, `Product`.`calorie`, (`ProductRLang`.`title`) AS `Product__title` FROM `qqrice_test`.`booster_products` AS `Product` INNER JOIN `qqrice_test`.`booster_product_languages` AS `ProductRLang` ON (((`ProductRLang`.`product_id` = `Product`.`id`) AND (`ProductRLang`.`alias` = 'zho'))) WHERE `Product`.`enabled` = '1' AND `Product`.`product_number` != 'DS003CN' AND `Product`.`product_type_id` = 2 AND `Product`.`channel_type_id` IN (1, 3, 4, 5) ORDER BY rand() ASC LIMIT 3 | 3 | 3 | 47 | maybe slow |
Peak Memory Use 15.44 MB
| Message | Memory use |
|---|---|
| Component initialization | 1.05 MB |
| Controller action start | 1.77 MB |
| Controller render start | 2.08 MB |
| View render complete | 2.74 MB |
Total Request Time: 360 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 6.32 | |
| Event: Controller.initialize | 271.12 | |
| Event: Controller.startup | 0.52 | |
| Controller action | 55.98 | |
| Event: Controller.beforeRender | 7.50 | |
| » Processing toolbar data | 7.40 | |
| Rendering View | 7.14 | |
| » Event: View.beforeRender | 0.02 | |
| » Rendering APP/Plugin/Frontend/View/FrontendProducts/detail.ctp | 4.62 | |
| » » Rendering APP/Plugin/Frontend/View/Elements/header.ctp | 2.42 | |
| » » » Rendering APP/Plugin/Frontend/View/Elements/header_mobile_menu.ctp | 0.06 | |
| » » » Rendering APP/Plugin/Frontend/View/Elements/wishlist.ctp | 0.03 | |
| » » » Rendering APP/Plugin/Frontend/View/Elements/cartlist.ctp | 0.64 | |
| » » Rendering APP/Plugin/Frontend/View/Elements/breadcrumb.ctp | 0.04 | |
| » » Rendering APP/Plugin/Frontend/View/Elements/comment_box.ctp | 0.07 | |
| » » Rendering APP/Plugin/Frontend/View/Elements/product_list.ctp | 0.10 | |
| » Event: View.afterRender | 0.01 | |
| » Event: View.beforeLayout | 0.01 | |
| » Rendering APP/Plugin/Frontend/View/Layouts/front.ctp | 2.04 | |
| » » Rendering APP/Plugin/Frontend/View/Elements/function/my_alert.ctp | 0.10 | |
| » » Rendering APP/Plugin/Frontend/View/Elements/function/confirm_box.ctp | 0.04 | |
| » » Rendering APP/Plugin/Frontend/View/Elements/function/my_choice.ctp | 0.04 | |
| » » Rendering APP/Plugin/Frontend/View/Elements/function/my_loading.ctp | 0.04 | |
| » » Rendering APP/Plugin/Frontend/View/Elements/loading_popup.ctp | 0.04 | |
| » » Rendering APP/Plugin/Frontend/View/Elements/footer.ctp | 0.10 | |
| » Rendering APP/Plugin/Chatbot/View/Elements/front.ctp #2 | 0.19 | |
| Event: View.afterLayout | 0.00 |
| Constant | Value |
|---|---|
| CONFIG | '/var/www/localhost/htdocs/Config/' |
| PHPEXCEL_ROOT | '/var/www/localhost/htdocs/Plugin/PhpExcel/Vendor/' |
| Constant | Value |
|---|---|
| APP | '/var/www/localhost/htdocs/' |
| APP_DIR | 'htdocs' |
| APPLIBS | '/var/www/localhost/htdocs/Lib/' |
| CACHE | '/var/www/localhost/htdocs/tmp/cache/' |
| CAKE | '/var/www/localhost/htdocs/Vendor/cakephp/cakephp/lib/Cake/' |
| CAKE_CORE_INCLUDE_PATH | '/var/www/localhost/htdocs/Vendor/cakephp/cakephp/lib' |
| CORE_PATH | '/var/www/localhost/htdocs/Vendor/cakephp/cakephp/lib/' |
| CAKE_VERSION | '2.10.22' |
| CSS | '/var/www/localhost/htdocs/webroot/css/' |
| CSS_URL | 'css/' |
| DS | '/' |
| FULL_BASE_URL | 'https://test.qqrice.com.hk' |
| IMAGES | '/var/www/localhost/htdocs/webroot/img/' |
| IMAGES_URL | 'img/' |
| JS | '/var/www/localhost/htdocs/webroot/js/' |
| JS_URL | 'js/' |
| LOGS | '/var/www/localhost/htdocs/tmp/logs/' |
| ROOT | '/var/www/localhost' |
| TESTS | '/var/www/localhost/htdocs/Test/' |
| TMP | '/var/www/localhost/htdocs/tmp/' |
| VENDORS | '/var/www/localhost/vendors/' |
| WEBROOT_DIR | 'webroot' |
| WWW_ROOT | '/var/www/localhost/htdocs/webroot/' |
| Environment Variable | Value |
|---|---|
| Php Version | '7.3.27' |
| Redirect Redirect Status | '200' |
| Redirect Status | '200' |
| Http Host | 'test.qqrice.com.hk' |
| Http User Agent | 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' |
| Http Accept | '*/*' |
| Http Accept Encoding | 'gzip, br, zstd, deflate' |
| Http X Forwarded For | '3.144.201.213' |
| Http X Forwarded Host | 'test.qqrice.com.hk' |
| Http X Forwarded Port | '443' |
| Http X Forwarded Proto | 'https' |
| Http X Forwarded Server | '54ec7f1b4ab9' |
| Http X Real Ip | '3.144.201.213' |
| Path | '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin' |
| Server Signature | 'Apache/2.4.46 (Unix) Server at 8.210.211.138 Port 9110 ' |
| Server Software | 'Apache/2.4.46 (Unix)' |
| Server Name | '8.210.211.138' |
| Server Addr | '172.18.0.4' |
| Server Port | '9110' |
| Remote Addr | '8.210.211.138' |
| Document Root | '/var/www/localhost/htdocs' |
| Request Scheme | 'http' |
| Context Prefix | '' |
| Context Document Root | '/var/www/localhost/htdocs' |
| Server Admin | 'you@example.com' |
| Script Filename | '/var/www/localhost/htdocs/webroot/index.php' |
| Remote Port | '55420' |
| Redirect Url | '/webroot/product/detail/DS003CN/低糖黑豆漿' |
| Gateway Interface | 'CGI/1.1' |
| Server Protocol | 'HTTP/1.1' |
| Request Method | 'GET' |
| Query String | '' |
| Request Uri | '/product/detail/DS003CN/%E4%BD%8E%E7%B3%96%E9%BB%91%E8%B1%86%E6%BC%BF' |
| Script Name | '/webroot/index.php' |
| Php Self | '/webroot/index.php' |
| Request Time Float | (float) 1746371655.7872 |
| Request Time | (int) 1746371655 |
| Https | 'on' |
