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 | 1 | maybe slow |
| 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`.`sale_price`, `Product`.`promote_price`, `Product`.`net_weight`, `Product`.`calorie`, (`ProductLang`.`title`) AS `Product__title` FROM `qqrice_test`.`booster_products` AS `Product` INNER JOIN `qqrice_test`.`booster_product_languages` AS `ProductLang` ON (((`ProductLang`.`product_id` = `Product`.`id`) AND (`ProductLang`.`alias` = 'zho'))) INNER JOIN `qqrice_test`.`booster_product_types` AS `ProductT` ON (`ProductT`.`id` = `Product`.`product_type_id`) WHERE `Product`.`enabled` = '1' AND `Product`.`channel_type_id` IN (1, 3, 4, 5) AND `ProductT`.`slug` = 'snacks' ORDER BY (`ProductLang`.`title`) asc LIMIT 12 | 0 | 0 | 0 | |
| SELECT COUNT(*) AS `count` FROM `qqrice_test`.`booster_products` AS `Product` INNER JOIN `qqrice_test`.`booster_product_types` AS `ProductT` ON (`ProductT`.`id` = `Product`.`product_type_id`) WHERE `Product`.`enabled` = '1' AND `Product`.`channel_type_id` IN (1, 3, 4, 5) AND `ProductT`.`slug` = 'snacks' | 1 | 1 | 0 | |
| SELECT `ProductBanner`.`sorting`, `ProductBanner`.`path`, `ProductBanner`.`linkage` FROM `qqrice_test`.`booster_product_banners` AS `ProductBanner` WHERE `ProductBanner`.`enabled` = '1' AND ((`ProductBanner`.`unpublish_date` > '2025-05-04') OR (`ProductBanner`.`unpublish_date` is NULL)) ORDER BY `ProductBanner`.`sorting` asc | 4 | 4 | 0 |
Peak Memory Use 16.66 MB
| Message | Memory use |
|---|---|
| Component initialization | 1.05 MB |
| Controller action start | 15.13 MB |
| Controller render start | 15.30 MB |
| View render complete | 15.94 MB |
Total Request Time: 185 (ms)
| Message | Time in ms | Graph |
|---|---|---|
| Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 5.68 | |
| Event: Controller.initialize | 157.48 | |
| Event: Controller.startup | 0.38 | |
| Controller action | 4.90 | |
| Event: Controller.beforeRender | 4.82 | |
| » Processing toolbar data | 4.75 | |
| Rendering View | 5.30 | |
| » Event: View.beforeRender | 0.01 | |
| » Rendering APP/Plugin/Frontend/View/FrontendShops/index.ctp | 3.59 | |
| » » Rendering APP/Plugin/Frontend/View/Elements/header.ctp | 2.58 | |
| » » » 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.46 | |
| » » Rendering APP/Plugin/Frontend/View/Elements/breadcrumb.ctp | 0.04 | |
| » » Rendering APP/Plugin/Frontend/View/Elements/product_list.ctp | 0.77 | |
| » Event: View.afterRender | 0.01 | |
| » Event: View.beforeLayout | 0.01 | |
| » Rendering APP/Plugin/Frontend/View/Layouts/front.ctp | 1.37 | |
| » » Rendering APP/Plugin/Frontend/View/Elements/function/my_alert.ctp | 0.07 | |
| » » Rendering APP/Plugin/Frontend/View/Elements/function/confirm_box.ctp | 0.03 | |
| » » Rendering APP/Plugin/Frontend/View/Elements/function/my_choice.ctp | 0.03 | |
| » » Rendering APP/Plugin/Frontend/View/Elements/function/my_loading.ctp | 0.02 | |
| » » Rendering APP/Plugin/Frontend/View/Elements/loading_popup.ctp | 0.02 | |
| » » Rendering APP/Plugin/Frontend/View/Elements/footer.ctp | 0.05 | |
| » Rendering APP/Plugin/Chatbot/View/Elements/front.ctp #2 | 0.13 | |
| 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 | '13.59.84.174' |
| 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 | '13.59.84.174' |
| 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 | '41334' |
| Redirect Url | '/webroot/online/shops/snacks/零食' |
| Gateway Interface | 'CGI/1.1' |
| Server Protocol | 'HTTP/1.1' |
| Request Method | 'GET' |
| Query String | '' |
| Request Uri | '/online/shops/snacks/%E9%9B%B6%E9%A3%9F' |
| Script Name | '/webroot/index.php' |
| Php Self | '/webroot/index.php' |
| Request Time Float | (float) 1746337230.6347 |
| Request Time | (int) 1746337230 |
| Https | 'on' |
