[ BEHAVIOR ] Run addons\visituser\Hook @user_visit_record [ RunTime:0.000963s ]
[ BEHAVIOR ] Run addons\visituser\Hook @response_send [ RunTime:0.000042s ]
[ DB ] CONNECT:[ UseTime:0.001979s ] mysql:host=database-test2.cb81pdkxodkj.us-east-1.rds.amazonaws.com:3306;port=3306;dbname=shoppaas_1720249832071;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `themes_lang` [ RunTime:0.001479s ]
[ SQL ] SELECT * FROM `themes_lang` WHERE ( is_enable = 1 ) [ RunTime:0.001631s ]
[ SQL ] SHOW COLUMNS FROM `marketing_form` [ RunTime:0.001610s ]
[ SQL ] SELECT * FROM `marketing_form` WHERE `tob` = 1 LIMIT 1 [ RunTime:0.000949s ]
[ SQL ] SHOW COLUMNS FROM `config` [ RunTime:0.001188s ]
[ SQL ] SELECT * FROM `config` WHERE `name` LIKE 'tob%' [ RunTime:0.000978s ]
[ SQL ] set time_zone = '+08:00' [ RunTime:0.000835s ]
[ SQL ] SELECT `value` FROM `config` WHERE ( name = 'multiCurrencySwitch' ) LIMIT 1 [ RunTime:0.000907s ]
[ SQL ] SELECT `value` FROM `config` WHERE ( name = 'byIpSwitch' ) LIMIT 1 [ RunTime:0.000943s ]
[ SQL ] SHOW COLUMNS FROM `cart` [ RunTime:0.001495s ]
[ SQL ] SHOW COLUMNS FROM `product` [ RunTime:0.001424s ]
[ SQL ] UPDATE `cart` SET `deletetime`=1775382670 WHERE ( NOT EXISTS ( SELECT * FROM `product` WHERE ( product.id=cart.product_id ) ) AND `user_id` = 0 AND `session_id` = '17dlnt6b9hvtkc1q3v9ncfk1rq' ) AND `cart`.`deletetime` IS NULL [ RunTime:0.000953s ]
[ SQL ] SHOW COLUMNS FROM `activity` [ RunTime:0.001281s ]
[ SQL ] set session sql_mode='STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' [ RunTime:0.000707s ]
[ SQL ] SELECT * FROM `cart` LEFT JOIN ( SELECT type as activity_type,id as activity_id,`product_ids` FROM `activity` WHERE ( `type` IN ('seckill') ) AND `activity`.`deletetime` IS NULL ) `act` ON find_in_set(cart.product_id, product_ids) WHERE ( `user_id` = 0 AND `session_id` = '17dlnt6b9hvtkc1q3v9ncfk1rq' ) AND `cart`.`deletetime` IS NULL GROUP BY `id` ORDER BY `createtime` DESC [ RunTime:0.001447s ]
[ SQL ] set session sql_mode='STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' [ RunTime:0.000679s ]
[ SQL ] SHOW COLUMNS FROM `visit_user` [ RunTime:0.001639s ]
[ SQL ] SELECT * FROM `visit_user` WHERE `visit_code` = '459db359d4bb02124051f107c32f355f' LIMIT 1 [ RunTime:0.001021s ]
[ SQL ] SHOW COLUMNS FROM `visit_log` [ RunTime:0.001459s ]
[ SQL ] SELECT * FROM `visit_log` WHERE ( `visit_session` = '7fc81919e4a12cc8bafaa00184d98d30' ) AND `visit_log`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.001113s ]
[ SQL ] UPDATE `cart` SET `deletetime`=1775382670 WHERE ( NOT EXISTS ( SELECT * FROM `product` WHERE ( product.id=cart.product_id ) ) AND `user_id` = 0 AND `session_id` = '17dlnt6b9hvtkc1q3v9ncfk1rq' ) AND `cart`.`deletetime` IS NULL [ RunTime:0.001041s ]
[ SQL ] set session sql_mode='STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' [ RunTime:0.000733s ]
[ SQL ] SELECT * FROM `cart` LEFT JOIN ( SELECT type as activity_type,id as activity_id,`product_ids` FROM `activity` WHERE ( `type` IN ('seckill') ) AND `activity`.`deletetime` IS NULL ) `act` ON find_in_set(cart.product_id, product_ids) WHERE ( `user_id` = 0 AND `session_id` = '17dlnt6b9hvtkc1q3v9ncfk1rq' ) AND `cart`.`deletetime` IS NULL GROUP BY `id` ORDER BY `createtime` DESC [ RunTime:0.001431s ]
[ SQL ] set session sql_mode='STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' [ RunTime:0.000747s ]
[ SQL ] SHOW COLUMNS FROM `themes_menu_item` [ RunTime:0.001704s ]
[ SQL ] SELECT * FROM `themes_menu_item` WHERE ( ( menu_id = '' and pid = 0 ) ) AND `themes_menu_item`.`deletetime` IS NULL ORDER BY `weigh`,`id` [ RunTime:0.001227s ]
[ SQL ] SELECT * FROM `themes_menu_item` WHERE ( ( menu_id = '' and pid = 0 ) ) AND `themes_menu_item`.`deletetime` IS NULL ORDER BY `weigh`,`id` [ RunTime:0.001152s ]