[ DB ] CONNECT:[ UseTime:0.002614s ] 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.001059s ]
[ SQL ] SELECT `area_id` FROM `access_control_blacklist` [ RunTime:0.001182s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `access_control_iplist` WHERE `type` = '2' AND `ip` = '216.73.216.31' LIMIT 1 [ RunTime:0.001054s ]
[ SQL ] SELECT `ip` FROM `access_control_iplist` WHERE `type` = '1' [ RunTime:0.000822s ]
[ SQL ] SELECT `code` FROM `area` WHERE `id` IN ('') [ RunTime:0.000783s ]
[ SQL ] SELECT * FROM `payment` WHERE `status` = '1' ORDER BY `weigh` DESC,`id` ASC [ RunTime:0.001070s ]
[ SQL ] SELECT `value` FROM `config` WHERE `name` = 'channel_google' LIMIT 1 [ RunTime:0.001056s ]
[ SQL ] SELECT `value` FROM `config` WHERE `name` = 'lang_auto_detect' LIMIT 1 [ RunTime:0.001000s ]
[ SQL ] set time_zone = '+08:00' [ RunTime:0.000861s ]
[ SQL ] SELECT `value` FROM `config` WHERE ( name = 'multiCurrencySwitch' ) LIMIT 1 [ RunTime:0.000868s ]
[ SQL ] SELECT `value` FROM `config` WHERE ( name = 'byIpSwitch' ) LIMIT 1 [ RunTime:0.000914s ]
[ SQL ] SELECT `value` FROM `config` WHERE `name` = 'customer_login_config' LIMIT 1 [ RunTime:0.000965s ]
[ SQL ] SELECT * FROM `category` [ RunTime:0.001234s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('1',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.000965s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('2',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.000872s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('3',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.000963s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('4',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.000980s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('5',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.000830s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` WHERE ( `status` = 'up' ) AND `product`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.000838s ]
[ SQL ] SELECT * FROM `product` WHERE ( `status` = 'up' ) AND `product`.`deletetime` IS NULL LIMIT 0,2000 [ RunTime:0.001540s ]
[ SQL ] SELECT `value` FROM `config` WHERE `name` = 'klaviyo_config' LIMIT 1 [ RunTime:0.001095s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `app_center` WHERE `name` = 'salesmartly' AND `is_installed` = 1 LIMIT 1 [ RunTime:0.000870s ]
[ SQL ] SELECT * FROM `themes_menu_item` WHERE `themes_menu_item`.`deletetime` IS NULL [ RunTime:0.000816s ]
[ 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.000932s ]
[ SQL ] SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/assets/shop/img/svg/no-image.svg' LIMIT 1 [ RunTime:0.000915s ]
[ 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.000818s ]
[ SQL ] SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/assets/shop/img/svg/no-image.svg' LIMIT 1 [ RunTime:0.000836s ]
2/28 . SELECT * FROM `product` WHERE ( `status` = 'up' ) AND `product`.`deletetime` IS NULL LIMIT 0,2000 [0.001540s/0.028752s=5.36%]
3/28 . SELECT * FROM `category` [0.001234s/0.028752s=4.29%]
4/28 . SELECT `area_id` FROM `access_control_blacklist` [0.001182s/0.028752s=4.11%]
5/28 . SELECT `value` FROM `config` WHERE `name` = 'klaviyo_config' LIMIT 1 [0.001095s/0.028752s=3.81%]
6/28 . SELECT * FROM `payment` WHERE `status` = '1' ORDER BY `weigh` DESC,`id` ASC [0.001070s/0.028752s=3.72%]
7/28 . SELECT COUNT(*) AS tp_count FROM `app_center` WHERE `name` = 'access_control' AND `is_installed` = 1 LIMIT 1 [0.001059s/0.028752s=3.68%]
8/28 . SELECT `value` FROM `config` WHERE `name` = 'channel_google' LIMIT 1 [0.001056s/0.028752s=3.67%]
9/28 . SELECT COUNT(*) AS tp_count FROM `access_control_iplist` WHERE `type` = '2' AND `ip` = '216.73.216.31' LIMIT 1 [0.001054s/0.028752s=3.67%]
10/28 . SELECT `value` FROM `config` WHERE `name` = 'lang_auto_detect' LIMIT 1 [0.001000s/0.028752s=3.48%]
11/28 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('4',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.000980s/0.028752s=3.41%]
12/28 . SELECT `value` FROM `config` WHERE `name` = 'customer_login_config' LIMIT 1 [0.000965s/0.028752s=3.36%]
13/28 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('1',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.000965s/0.028752s=3.36%]
14/28 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('3',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.000963s/0.028752s=3.35%]
15/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.000932s/0.028752s=3.24%]
16/28 . SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/assets/shop/img/svg/no-image.svg' LIMIT 1 [0.000915s/0.028752s=3.18%]
17/28 . SELECT `value` FROM `config` WHERE ( name = 'byIpSwitch' ) LIMIT 1 [0.000914s/0.028752s=3.18%]
18/28 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('2',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.000872s/0.028752s=3.03%]
19/28 . SELECT COUNT(*) AS tp_count FROM `app_center` WHERE `name` = 'salesmartly' AND `is_installed` = 1 LIMIT 1 [0.000870s/0.028752s=3.03%]
20/28 . SELECT `value` FROM `config` WHERE ( name = 'multiCurrencySwitch' ) LIMIT 1 [0.000868s/0.028752s=3.02%]
21/28 . set time_zone = '+08:00' [0.000861s/0.028752s=2.99%]
22/28 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( `status` = 'up' ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.000838s/0.028752s=2.91%]
23/28 . SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/assets/shop/img/svg/no-image.svg' LIMIT 1 [0.000836s/0.028752s=2.91%]
24/28 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('5',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.000830s/0.028752s=2.89%]
25/28 . SELECT `ip` FROM `access_control_iplist` WHERE `type` = '1' [0.000822s/0.028752s=2.86%]
26/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.000818s/0.028752s=2.85%]
27/28 . SELECT * FROM `themes_menu_item` WHERE `themes_menu_item`.`deletetime` IS NULL [0.000816s/0.028752s=2.84%]
28/28 . SELECT `code` FROM `area` WHERE `id` IN ('') [0.000783s/0.028752s=2.72%]
1/2. SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/assets/shop/img/svg/no-image.svg' LIMIT 1 [2 times, 0.001751s/0.028752s=6.09%]
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.00175s/0.028752s=6.09%]