[ DB ] CONNECT:[ UseTime:0.001929s ] mysql:host=172.31.96.182;port=3306;dbname=shoppaas_1721902879172;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `themes_onepage_store` [ RunTime:0.008610s ]
[ SQL ] SELECT `id` FROM `themes_onepage_store` WHERE `mode` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.000480s ]
[ SQL ] SHOW COLUMNS FROM `themes_lang` [ RunTime:0.005530s ]
[ SQL ] SELECT * FROM `themes_lang` WHERE ( is_enable = 1 AND is_publish=1 AND deletetime IS NULL ) ORDER BY `is_default` DESC,`sort` DESC [ RunTime:0.000520s ]
[ SQL ] SHOW COLUMNS FROM `payment` [ RunTime:0.008908s ]
[ SQL ] SELECT * FROM `payment` WHERE `status` = '1' ORDER BY `weigh` DESC,`id` ASC [ RunTime:0.000529s ]
[ SQL ] SELECT * FROM `payment` WHERE `status` = '1' AND ( code != 'test' ) [ RunTime:0.004152s ]
[ SQL ] SHOW COLUMNS FROM `config` [ RunTime:0.008099s ]
[ SQL ] SELECT `value` FROM `config` WHERE `name` = 'lang_auto_detect' LIMIT 1 [ RunTime:0.001018s ]
[ SQL ] set time_zone = '+08:00' [ RunTime:0.000311s ]
[ SQL ] SELECT `value` FROM `config` WHERE ( name = 'multiCurrencySwitch' ) LIMIT 1 [ RunTime:0.001227s ]
[ SQL ] SHOW COLUMNS FROM `currency` [ RunTime:0.007636s ]
[ SQL ] SELECT * FROM `currency` WHERE `status` = 1 ORDER BY `sort` DESC [ RunTime:0.001089s ]
[ SQL ] SELECT `value` FROM `config` WHERE ( name = 'byIpSwitch' ) LIMIT 1 [ RunTime:0.000336s ]
[ SQL ] SELECT * FROM `currency` WHERE `code` = 'USD' LIMIT 1 [ RunTime:0.000334s ]
[ SQL ] SHOW COLUMNS FROM `cart` [ RunTime:0.005722s ]
[ SQL ] SHOW COLUMNS FROM `product` [ RunTime:0.008999s ]
[ SQL ] UPDATE `cart` SET `deletetime`=1743572950 WHERE ( NOT EXISTS ( SELECT * FROM `product` WHERE ( product.id=cart.product_id ) ) AND `user_id` = 0 AND `session_id` = '5relraqhd1qpg1mhcenu7evk6a' AND `createtime` > 1743313750 ) AND `cart`.`deletetime` IS NULL [ RunTime:0.003695s ]
[ SQL ] SHOW COLUMNS FROM `activity` [ RunTime:0.009295s ]
[ SQL ] set session sql_mode='STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' [ RunTime:0.000263s ]
[ 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` = '5relraqhd1qpg1mhcenu7evk6a' AND `store_id` = 0 ) AND `cart`.`deletetime` IS NULL GROUP BY `id` ORDER BY `createtime` DESC [ RunTime:0.001184s ]
[ SQL ] set session sql_mode='STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' [ RunTime:0.000537s ]
[ SQL ] SELECT `value` FROM `config` WHERE `name` = 'customer_login_config' LIMIT 1 [ RunTime:0.000552s ]
[ SQL ] SHOW COLUMNS FROM `visit_user` [ RunTime:0.007276s ]
[ SQL ] SELECT * FROM `visit_user` WHERE `visit_code` = '2de4f66135768ab8fb6111bea621ac54' LIMIT 1 [ RunTime:0.005351s ]
[ SQL ] SHOW COLUMNS FROM `visit_log` [ RunTime:0.004589s ]
[ SQL ] SELECT * FROM `visit_log` WHERE ( `visit_session` = '75ec816797b2ded547717a97d568530d' ) AND `visit_log`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.004771s ]
[ SQL ] SHOW COLUMNS FROM `app_center` [ RunTime:0.003424s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `app_center` WHERE `name` = 'access_control' AND `is_installed` = 1 LIMIT 1 [ RunTime:0.000435s ]
[ SQL ] SHOW COLUMNS FROM `themes_menu_item` [ RunTime:0.003880s ]
[ SQL ] SELECT * FROM `themes_menu_item` WHERE `themes_menu_item`.`deletetime` IS NULL [ RunTime:0.000411s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `themes_lang` WHERE ( lang_name='en' AND is_enable=1 AND transl_way=2 AND deletetime IS NULL ) LIMIT 1 [ RunTime:0.000353s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` WHERE ( `status` = 'up' AND `deletetime` IS NULL AND `id` IN (6,8,9,11,14,18,21,25) ) AND `product`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.002300s ]
[ SQL ] SELECT * FROM `product` WHERE ( `status` = 'up' AND `deletetime` IS NULL AND `id` IN (6,8,9,11,14,18,21,25) ) AND `product`.`deletetime` IS NULL ORDER BY field(id,6,8,9,11,14,18,21,25) LIMIT 0,24 [ RunTime:0.000708s ]
[ SQL ] SHOW COLUMNS FROM `discuss` [ RunTime:0.005234s ]
[ SQL ] SELECT * FROM `discuss` WHERE ( `status` = 'show' AND `product_id` IN (6,8,9,11,14,18,21,25) ) AND `discuss`.`deletetime` IS NULL [ RunTime:0.000480s ]
[ SQL ] SHOW COLUMNS FROM `product_sku_price` [ RunTime:0.009569s ]
[ SQL ] SELECT * FROM `product_sku_price` WHERE ( `product_id` IN (6,8,9,11,14,18,21,25) ) AND `product_sku_price`.`deletetime` IS NULL ORDER BY `weigh` ASC,`id` ASC [ RunTime:0.001335s ]
[ SQL ] SELECT * FROM `activity` WHERE ( ( 1743572950 > starttime && 1743572950 < endtime ) ) AND `activity`.`deletetime` IS NULL ORDER BY `starttime` ASC LIMIT 30 [ RunTime:0.000392s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `themes_lang` WHERE ( lang_name='en' AND is_enable=1 AND transl_way=2 AND deletetime IS NULL ) LIMIT 1 [ RunTime:0.000408s ]
1/42 . SHOW COLUMNS FROM `product_sku_price` [0.009569s/0.132322s=7.23%]
2/42 . SHOW COLUMNS FROM `activity` [0.009295s/0.132322s=7.02%]
3/42 . SHOW COLUMNS FROM `product` [0.008999s/0.132322s=6.80%]
4/42 . SHOW COLUMNS FROM `payment` [0.008908s/0.132322s=6.73%]
5/42 . SHOW COLUMNS FROM `themes_onepage_store` [0.008610s/0.132322s=6.51%]
6/42 . SHOW COLUMNS FROM `config` [0.008099s/0.132322s=6.12%]
7/42 . SHOW COLUMNS FROM `currency` [0.007636s/0.132322s=5.77%]
8/42 . SHOW COLUMNS FROM `visit_user` [0.007276s/0.132322s=5.50%]
9/42 . SHOW COLUMNS FROM `cart` [0.005722s/0.132322s=4.32%]
10/42 . SHOW COLUMNS FROM `themes_lang` [0.005530s/0.132322s=4.18%]
11/42 . SELECT * FROM `visit_user` WHERE `visit_code` = '2de4f66135768ab8fb6111bea621ac54' LIMIT 1 [0.005351s/0.132322s=4.04%]
12/42 . SHOW COLUMNS FROM `discuss` [0.005234s/0.132322s=3.96%]
13/42 . SELECT * FROM `visit_log` WHERE ( `visit_session` = '75ec816797b2ded547717a97d568530d' ) AND `visit_log`.`deletetime` IS NULL LIMIT 1 [0.004771s/0.132322s=3.61%]
14/42 . SHOW COLUMNS FROM `visit_log` [0.004589s/0.132322s=3.47%]
15/42 . SELECT * FROM `payment` WHERE `status` = '1' AND ( code != 'test' ) [0.004152s/0.132322s=3.14%]
16/42 . SHOW COLUMNS FROM `themes_menu_item` [0.003880s/0.132322s=2.93%]
17/42 . UPDATE `cart` SET `deletetime`=1743572950 WHERE ( NOT EXISTS ( SELECT * FROM `product` WHERE ( product.id=cart.product_id ) ) AND `user_id` = 0 AND `session_id` = '5relraqhd1qpg1mhcenu7evk6a' AND `createtime` > 1743313750 ) AND `cart`.`deletetime` IS NULL [0.003695s/0.132322s=2.79%]
18/42 . SHOW COLUMNS FROM `app_center` [0.003424s/0.132322s=2.59%]
19/42 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( `status` = 'up' AND `deletetime` IS NULL AND `id` IN (6,8,9,11,14,18,21,25) ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.002300s/0.132322s=1.74%]
21/42 . SELECT * FROM `product_sku_price` WHERE ( `product_id` IN (6,8,9,11,14,18,21,25) ) AND `product_sku_price`.`deletetime` IS NULL ORDER BY `weigh` ASC,`id` ASC [0.001335s/0.132322s=1.01%]
22/42 . SELECT `value` FROM `config` WHERE ( name = 'multiCurrencySwitch' ) LIMIT 1 [0.001227s/0.132322s=0.93%]
23/42 . 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` = '5relraqhd1qpg1mhcenu7evk6a' AND `store_id` = 0 ) AND `cart`.`deletetime` IS NULL GROUP BY `id` ORDER BY `createtime` DESC [0.001184s/0.132322s=0.89%]
24/42 . SELECT * FROM `currency` WHERE `status` = 1 ORDER BY `sort` DESC [0.001089s/0.132322s=0.82%]
25/42 . SELECT `value` FROM `config` WHERE `name` = 'lang_auto_detect' LIMIT 1 [0.001018s/0.132322s=0.77%]
26/42 . SELECT * FROM `product` WHERE ( `status` = 'up' AND `deletetime` IS NULL AND `id` IN (6,8,9,11,14,18,21,25) ) AND `product`.`deletetime` IS NULL ORDER BY field(id,6,8,9,11,14,18,21,25) LIMIT 0,24 [0.000708s/0.132322s=0.54%]
27/42 . SELECT `value` FROM `config` WHERE `name` = 'customer_login_config' LIMIT 1 [0.000552s/0.132322s=0.42%]
28/42 . set session sql_mode='STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' [0.000537s/0.132322s=0.41%]
29/42 . SELECT * FROM `payment` WHERE `status` = '1' ORDER BY `weigh` DESC,`id` ASC [0.000529s/0.132322s=0.40%]
30/42 . SELECT * FROM `themes_lang` WHERE ( is_enable = 1 AND is_publish=1 AND deletetime IS NULL ) ORDER BY `is_default` DESC,`sort` DESC [0.000520s/0.132322s=0.39%]
31/42 . SELECT `id` FROM `themes_onepage_store` WHERE `mode` = 1 AND `status` = 1 LIMIT 1 [0.000480s/0.132322s=0.36%]
32/42 . SELECT * FROM `discuss` WHERE ( `status` = 'show' AND `product_id` IN (6,8,9,11,14,18,21,25) ) AND `discuss`.`deletetime` IS NULL [0.000480s/0.132322s=0.36%]
34/42 . SELECT COUNT(*) AS tp_count FROM `app_center` WHERE `name` = 'access_control' AND `is_installed` = 1 LIMIT 1 [0.000435s/0.132322s=0.33%]
35/42 . SELECT * FROM `themes_menu_item` WHERE `themes_menu_item`.`deletetime` IS NULL [0.000411s/0.132322s=0.31%]
36/42 . SELECT COUNT(*) AS tp_count FROM `themes_lang` WHERE ( lang_name='en' AND is_enable=1 AND transl_way=2 AND deletetime IS NULL ) LIMIT 1 [0.000408s/0.132322s=0.31%]
37/42 . SELECT * FROM `activity` WHERE ( ( 1743572950 > starttime && 1743572950 < endtime ) ) AND `activity`.`deletetime` IS NULL ORDER BY `starttime` ASC LIMIT 30 [0.000392s/0.132322s=0.30%]
38/42 . SELECT COUNT(*) AS tp_count FROM `themes_lang` WHERE ( lang_name='en' AND is_enable=1 AND transl_way=2 AND deletetime IS NULL ) LIMIT 1 [0.000353s/0.132322s=0.27%]
39/42 . SELECT `value` FROM `config` WHERE ( name = 'byIpSwitch' ) LIMIT 1 [0.000336s/0.132322s=0.25%]
40/42 . SELECT * FROM `currency` WHERE `code` = 'USD' LIMIT 1 [0.000334s/0.132322s=0.25%]
41/42 . set time_zone = '+08:00' [0.000311s/0.132322s=0.24%]
42/42 . set session sql_mode='STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' [0.000263s/0.132322s=0.20%]
1/2. SELECT COUNT(*) AS tp_count FROM `themes_lang` WHERE ( lang_name='en' AND is_enable=1 AND transl_way=2 AND deletetime IS NULL ) LIMIT 1 [2 times, 0.000761s/0.132322s=0.58%]
2/2. set session sql_mode='STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' [2 times, 0.0008s/0.132322s=0.60%]