[ DB ] CONNECT:[ UseTime:0.002878s ] mysql:host=test.cqdeqicu2sp5.us-east-1.rds.amazonaws.com:3306;port=3306;dbname=shoppaas_1702003318301;charset=utf8mb4
[ SQL ] SELECT COUNT(*) AS tp_count FROM `app_center` WHERE `name` = 'access_control' AND `is_installed` = 1 LIMIT 1 [ RunTime:0.001093s ]
[ SQL ] SELECT * FROM `payment` WHERE `status` = '1' ORDER BY `weigh` DESC,`id` ASC [ RunTime:0.001110s ]
[ SQL ] SELECT `value` FROM `config` WHERE `name` = 'channel_google' LIMIT 1 [ RunTime:0.000919s ]
[ SQL ] SELECT `value` FROM `config` WHERE `name` = 'lang_auto_detect' LIMIT 1 [ RunTime:0.001009s ]
[ SQL ] set time_zone = '+08:00' [ RunTime:0.000819s ]
[ SQL ] SELECT `value` FROM `config` WHERE ( name = 'multiCurrencySwitch' ) LIMIT 1 [ RunTime:0.000861s ]
[ SQL ] SELECT `value` FROM `config` WHERE ( name = 'byIpSwitch' ) LIMIT 1 [ RunTime:0.000864s ]
[ SQL ] SELECT `value` FROM `config` WHERE `name` = 'customer_login_config' LIMIT 1 [ RunTime:0.000925s ]
[ SQL ] SELECT * FROM `category` [ RunTime:0.001092s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('1',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.001110s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('2',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.000904s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` WHERE ( `status` = 'up' ) AND `product`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.001038s ]
[ SQL ] SELECT * FROM `product` WHERE ( `status` = 'up' ) AND `product`.`deletetime` IS NULL LIMIT 0,2000 [ RunTime:0.001916s ]
[ SQL ] SELECT `value` FROM `config` WHERE `name` = 'klaviyo_config' LIMIT 1 [ RunTime:0.001027s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `app_center` WHERE `name` = 'salesmartly' AND `is_installed` = 1 LIMIT 1 [ RunTime:0.001220s ]
[ SQL ] SELECT * FROM `themes_menu_item` WHERE `themes_menu_item`.`deletetime` IS NULL [ RunTime:0.000909s ]
[ 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.000880s ]
[ SQL ] SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/assets/shop/img/svg/no-image.svg' LIMIT 1 [ RunTime:0.000947s ]
[ 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.000871s ]
2/20 . SELECT * FROM `product` WHERE ( `status` = 'up' ) AND `product`.`deletetime` IS NULL LIMIT 0,2000 [0.001916s/0.022392s=8.56%]
3/20 . SELECT COUNT(*) AS tp_count FROM `app_center` WHERE `name` = 'salesmartly' AND `is_installed` = 1 LIMIT 1 [0.001220s/0.022392s=5.45%]
4/20 . SELECT * FROM `payment` WHERE `status` = '1' ORDER BY `weigh` DESC,`id` ASC [0.001110s/0.022392s=4.96%]
5/20 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('1',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.001110s/0.022392s=4.96%]
6/20 . SELECT COUNT(*) AS tp_count FROM `app_center` WHERE `name` = 'access_control' AND `is_installed` = 1 LIMIT 1 [0.001093s/0.022392s=4.88%]
7/20 . SELECT * FROM `category` [0.001092s/0.022392s=4.88%]
8/20 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( `status` = 'up' ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.001038s/0.022392s=4.64%]
9/20 . SELECT `value` FROM `config` WHERE `name` = 'klaviyo_config' LIMIT 1 [0.001027s/0.022392s=4.59%]
10/20 . SELECT `value` FROM `config` WHERE `name` = 'lang_auto_detect' LIMIT 1 [0.001009s/0.022392s=4.51%]
11/20 . SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/assets/shop/img/svg/no-image.svg' LIMIT 1 [0.000947s/0.022392s=4.23%]
12/20 . SELECT `value` FROM `config` WHERE `name` = 'customer_login_config' LIMIT 1 [0.000925s/0.022392s=4.13%]
13/20 . SELECT `value` FROM `config` WHERE `name` = 'channel_google' LIMIT 1 [0.000919s/0.022392s=4.10%]
14/20 . SELECT * FROM `themes_menu_item` WHERE `themes_menu_item`.`deletetime` IS NULL [0.000909s/0.022392s=4.06%]
15/20 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('2',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.000904s/0.022392s=4.04%]
16/20 . 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.000880s/0.022392s=3.93%]
17/20 . 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.000871s/0.022392s=3.89%]
18/20 . SELECT `value` FROM `config` WHERE ( name = 'byIpSwitch' ) LIMIT 1 [0.000864s/0.022392s=3.86%]
19/20 . SELECT `value` FROM `config` WHERE ( name = 'multiCurrencySwitch' ) LIMIT 1 [0.000861s/0.022392s=3.85%]
20/20 . set time_zone = '+08:00' [0.000819s/0.022392s=3.66%]
1/1. 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.001751s/0.022392s=7.82%]