[ DB ] CONNECT:[ UseTime:0.002202s ] mysql:host=database-test2.cb81pdkxodkj.us-east-1.rds.amazonaws.com:3306;port=3306;dbname=shoppaas_1691638558005;charset=utf8mb4
[ SQL ] SELECT COUNT(*) AS tp_count FROM `app_center` WHERE `name` = 'access_control' AND `is_installed` = 1 LIMIT 1 [ RunTime:0.000994s ]
[ SQL ] SELECT `area_id` FROM `access_control_blacklist` [ RunTime:0.000932s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `access_control_iplist` WHERE `type` = '2' AND `ip` = '216.73.216.31' LIMIT 1 [ RunTime:0.000963s ]
[ SQL ] SELECT `ip` FROM `access_control_iplist` WHERE `type` = '1' [ RunTime:0.000890s ]
[ SQL ] SELECT `code` FROM `area` WHERE `id` IN ('') [ RunTime:0.000854s ]
[ SQL ] SELECT * FROM `payment` WHERE `status` = '1' ORDER BY `weigh` DESC,`id` ASC [ RunTime:0.001780s ]
[ SQL ] SELECT `value` FROM `config` WHERE `name` = 'channel_google' LIMIT 1 [ RunTime:0.001037s ]
[ SQL ] SELECT `value` FROM `config` WHERE `name` = 'lang_auto_detect' LIMIT 1 [ RunTime:0.001251s ]
[ SQL ] set time_zone = '+08:00' [ RunTime:0.000920s ]
[ SQL ] SELECT `value` FROM `config` WHERE ( name = 'multiCurrencySwitch' ) LIMIT 1 [ RunTime:0.000961s ]
[ SQL ] SELECT `value` FROM `config` WHERE ( name = 'byIpSwitch' ) LIMIT 1 [ RunTime:0.001166s ]
[ SQL ] SELECT `value` FROM `config` WHERE `name` = 'customer_login_config' LIMIT 1 [ RunTime:0.001203s ]
[ SQL ] SELECT * FROM `category` [ RunTime:0.001380s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('1',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.001250s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('2',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.001066s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('3',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.001105s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('4',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.001140s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('5',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.001089s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` WHERE ( `status` = 'up' ) AND `product`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.001061s ]
[ SQL ] SELECT * FROM `product` WHERE ( `status` = 'up' ) AND `product`.`deletetime` IS NULL LIMIT 0,2000 [ RunTime:0.002027s ]
[ SQL ] SELECT `value` FROM `config` WHERE `name` = 'klaviyo_config' LIMIT 1 [ RunTime:0.003284s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `app_center` WHERE `name` = 'salesmartly' AND `is_installed` = 1 LIMIT 1 [ RunTime:0.001100s ]
[ SQL ] SELECT * FROM `themes_menu_item` WHERE `themes_menu_item`.`deletetime` IS NULL [ RunTime:0.001772s ]
[ 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.001102s ]
[ SQL ] SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/assets/shop/img/svg/no-image.svg' LIMIT 1 [ RunTime:0.001100s ]
[ 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.000998s ]
[ SQL ] SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/assets/shop/img/svg/no-image.svg' LIMIT 1 [ RunTime:0.000942s ]
1/28 . SELECT `value` FROM `config` WHERE `name` = 'klaviyo_config' LIMIT 1 [0.003284s/0.035569s=9.23%]
3/28 . SELECT * FROM `product` WHERE ( `status` = 'up' ) AND `product`.`deletetime` IS NULL LIMIT 0,2000 [0.002027s/0.035569s=5.70%]
4/28 . SELECT * FROM `payment` WHERE `status` = '1' ORDER BY `weigh` DESC,`id` ASC [0.001780s/0.035569s=5.00%]
5/28 . SELECT * FROM `themes_menu_item` WHERE `themes_menu_item`.`deletetime` IS NULL [0.001772s/0.035569s=4.98%]
6/28 . SELECT * FROM `category` [0.001380s/0.035569s=3.88%]
7/28 . SELECT `value` FROM `config` WHERE `name` = 'lang_auto_detect' LIMIT 1 [0.001251s/0.035569s=3.52%]
8/28 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('1',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.001250s/0.035569s=3.51%]
9/28 . SELECT `value` FROM `config` WHERE `name` = 'customer_login_config' LIMIT 1 [0.001203s/0.035569s=3.38%]
10/28 . SELECT `value` FROM `config` WHERE ( name = 'byIpSwitch' ) LIMIT 1 [0.001166s/0.035569s=3.28%]
11/28 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('4',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.001140s/0.035569s=3.21%]
12/28 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('3',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.001105s/0.035569s=3.11%]
13/28 . 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.001102s/0.035569s=3.10%]
14/28 . SELECT COUNT(*) AS tp_count FROM `app_center` WHERE `name` = 'salesmartly' AND `is_installed` = 1 LIMIT 1 [0.001100s/0.035569s=3.09%]
15/28 . SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/assets/shop/img/svg/no-image.svg' LIMIT 1 [0.001100s/0.035569s=3.09%]
16/28 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('5',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.001089s/0.035569s=3.06%]
17/28 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('2',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.001066s/0.035569s=3.00%]
18/28 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( `status` = 'up' ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.001061s/0.035569s=2.98%]
19/28 . SELECT `value` FROM `config` WHERE `name` = 'channel_google' LIMIT 1 [0.001037s/0.035569s=2.92%]
20/28 . 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.000998s/0.035569s=2.81%]
21/28 . SELECT COUNT(*) AS tp_count FROM `app_center` WHERE `name` = 'access_control' AND `is_installed` = 1 LIMIT 1 [0.000994s/0.035569s=2.79%]
22/28 . SELECT COUNT(*) AS tp_count FROM `access_control_iplist` WHERE `type` = '2' AND `ip` = '216.73.216.31' LIMIT 1 [0.000963s/0.035569s=2.71%]
23/28 . SELECT `value` FROM `config` WHERE ( name = 'multiCurrencySwitch' ) LIMIT 1 [0.000961s/0.035569s=2.70%]
24/28 . SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/assets/shop/img/svg/no-image.svg' LIMIT 1 [0.000942s/0.035569s=2.65%]
25/28 . SELECT `area_id` FROM `access_control_blacklist` [0.000932s/0.035569s=2.62%]
26/28 . set time_zone = '+08:00' [0.000920s/0.035569s=2.59%]
27/28 . SELECT `ip` FROM `access_control_iplist` WHERE `type` = '1' [0.000890s/0.035569s=2.50%]
28/28 . SELECT `code` FROM `area` WHERE `id` IN ('') [0.000854s/0.035569s=2.40%]
1/2. SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/assets/shop/img/svg/no-image.svg' LIMIT 1 [2 times, 0.002042s/0.035569s=5.74%]
2/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.0021s/0.035569s=5.90%]