售賣機
銷售點
銷售點
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 `Region`.`id`, (`RegionLang`.`name`) AS `Region__name` FROM `qqrice_test`.`booster_regions` AS `Region` INNER JOIN `qqrice_test`.`booster_region_languages` AS `RegionLang` ON (((`RegionLang`.`region_id` = `Region`.`id`) AND (`RegionLang`.`alias` = 'zho'))) WHERE `Region`.`enabled` = '1' ORDER BY `Region`.`sorting` asc | 3 | 3 | 0 | |
SELECT `VendingMachine`.`id`, `VendingMachine`.`path`, `VendingMachine`.`region_id`, `VendingMachine`.`district_id`, `VendingMachine`.`latitude`, `VendingMachine`.`longitude`, (`VendingMachineLang`.`address`) AS `VendingMachine__address`, (`VendingMachineLang`.`opening`) AS `VendingMachine__opening`, (`VendingMachineRegLang`.`name`) AS `VendingMachine__region`, (`VendingMachineDistLang`.`name`) AS `VendingMachine__district` FROM `qqrice_test`.`booster_vending_machines` AS `VendingMachine` INNER JOIN `qqrice_test`.`booster_vending_machine_languages` AS `VendingMachineLang` ON (((`VendingMachineLang`.`machine_id` = `VendingMachine`.`id`) AND (`VendingMachineLang`.`alias` = 'zho'))) INNER JOIN `qqrice_test`.`booster_region_languages` AS `VendingMachineRegLang` ON (((`VendingMachineRegLang`.`region_id` = `VendingMachine`.`region_id`) AND (`VendingMachineRegLang`.`alias` = 'zho'))) INNER JOIN `qqrice_test`.`booster_district_languages` AS `VendingMachineDistLang` ON (((`VendingMachineDistLang`.`district_id` = `VendingMachine`.`district_id`) AND (`VendingMachineDistLang`.`alias` = 'zho'))) WHERE `status` = 'enable' ORDER BY `VendingMachine`.`region_id` asc, `VendingMachine`.`district_id` asc | 55 | 55 | 1 |
Peak Memory Use 16.99 MB
Message | Memory use |
---|---|
Component initialization | 1.05 MB |
Controller action start | 15.14 MB |
Controller render start | 15.47 MB |
View render complete | 16.06 MB |
Total Request Time: 426 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 7.88 | |
Event: Controller.initialize | 345.96 | |
Event: Controller.startup | 0.43 | |
Controller action | 6.63 | |
Event: Controller.beforeRender | 6.41 | |
» Processing toolbar data | 6.33 | |
Rendering View | 5.54 | |
» Event: View.beforeRender | 0.02 | |
» Rendering APP/Plugin/Frontend/View/FrontendLocations/location.ctp | 3.04 | |
» » Rendering APP/Plugin/Frontend/View/Elements/header.ctp | 2.55 | |
» » » Rendering APP/Plugin/Frontend/View/Elements/header_mobile_menu.ctp | 0.06 | |
» » » Rendering APP/Plugin/Frontend/View/Elements/wishlist.ctp | 0.04 | |
» » » Rendering APP/Plugin/Frontend/View/Elements/cartlist.ctp | 0.25 | |
» » Rendering APP/Plugin/Frontend/View/Elements/breadcrumb.ctp | 0.04 | |
» Event: View.afterRender | 0.01 | |
» Event: View.beforeLayout | 0.01 | |
» Rendering APP/Plugin/Frontend/View/Layouts/front.ctp | 1.94 | |
» » 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.02 | |
» » 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.07 | |
» Rendering APP/Plugin/Chatbot/View/Elements/front.ctp #2 | 0.29 | |
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 | '18.222.153.166' |
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 | '18.222.153.166' |
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 | '42916' |
Redirect Url | '/webroot/vending-machine/location' |
Gateway Interface | 'CGI/1.1' |
Server Protocol | 'HTTP/1.1' |
Request Method | 'GET' |
Query String | '' |
Request Uri | '/vending-machine/location' |
Script Name | '/webroot/index.php' |
Php Self | '/webroot/index.php' |
Request Time Float | (float) 1746340767.4987 |
Request Time | (int) 1746340767 |
Https | 'on' |