[ DB ] CONNECT:[ UseTime:0.002203s ] mysql:host=database-test2.cb81pdkxodkj.us-east-1.rds.amazonaws.com:3306;port=3306;dbname=shoppaas_1704708690394;charset=utf8mb4
[ SQL ] SELECT `id` FROM `themes_onepage_store` WHERE `mode` = 1 AND `status` = 1 LIMIT 1 [ RunTime:0.001035s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `app_center` WHERE `name` = 'access_control' AND `is_installed` = 1 LIMIT 1 [ RunTime:0.001112s ]
[ SQL ] SELECT * FROM `payment` WHERE `status` = '1' ORDER BY `weigh` DESC,`id` ASC [ RunTime:0.001223s ]
[ SQL ] SELECT `value` FROM `config` WHERE `name` = 'channel_google' LIMIT 1 [ RunTime:0.001140s ]
[ SQL ] SELECT `value` FROM `config` WHERE `name` = 'lang_auto_detect' LIMIT 1 [ RunTime:0.001223s ]
[ SQL ] set time_zone = '+08:00' [ RunTime:0.001061s ]
[ SQL ] SELECT `value` FROM `config` WHERE ( name = 'multiCurrencySwitch' ) LIMIT 1 [ RunTime:0.001009s ]
[ SQL ] SELECT `value` FROM `config` WHERE ( name = 'byIpSwitch' ) LIMIT 1 [ RunTime:0.001100s ]
[ SQL ] SELECT `value` FROM `config` WHERE `name` = 'customer_login_config' LIMIT 1 [ RunTime:0.001220s ]
[ SQL ] SELECT `value` FROM `config` WHERE `name` = 'klaviyo_config' LIMIT 1 [ RunTime:0.001188s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `app_center` WHERE `name` = 'salesmartly' AND `is_installed` = 1 LIMIT 1 [ RunTime:0.002613s ]
[ SQL ] SELECT * FROM `themes_menu_item` WHERE `themes_menu_item`.`deletetime` IS NULL [ RunTime:0.001220s ]
[ 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.001050s ]
[ SQL ] SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/theme/dawn/images/yifu1.png' LIMIT 1 [ RunTime:0.001387s ]
[ 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` = '/theme/dawn/images/yifu2.png' LIMIT 1 [ RunTime:0.001193s ]
[ SQL ] SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/theme/dawn/images/yifu3.png' LIMIT 1 [ RunTime:0.001193s ]
[ SQL ] SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/theme/dawn/images/yifu4.png' LIMIT 1 [ RunTime:0.001301s ]
[ SQL ] SELECT * FROM `category` WHERE `id` = 0 AND `status` = 'normal' LIMIT 1 [ RunTime:0.002401s ]
[ SQL ] SELECT * FROM `category` [ RunTime:0.001188s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('1',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.001105s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('2',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.001159s ]
[ SQL ] SELECT * FROM `category` WHERE `id` = 0 AND `status` = 'normal' LIMIT 1 [ RunTime:0.003133s ]
[ SQL ] SELECT * FROM `category` [ RunTime:0.001095s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('1',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.001099s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('2',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.001148s ]
[ SQL ] SELECT * FROM `category` WHERE `id` = 0 AND `status` = 'normal' LIMIT 1 [ RunTime:0.001137s ]
[ SQL ] SELECT * FROM `category` [ RunTime:0.000998s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('1',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.001096s ]
[ 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 ]
1/31 . SELECT * FROM `category` WHERE `id` = 0 AND `status` = 'normal' LIMIT 1 [0.003133s/0.041036s=7.63%]
2/31 . SELECT COUNT(*) AS tp_count FROM `app_center` WHERE `name` = 'salesmartly' AND `is_installed` = 1 LIMIT 1 [0.002613s/0.041036s=6.37%]
3/31 . SELECT * FROM `category` WHERE `id` = 0 AND `status` = 'normal' LIMIT 1 [0.002401s/0.041036s=5.85%]
5/31 . SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/theme/dawn/images/yifu1.png' LIMIT 1 [0.001387s/0.041036s=3.38%]
6/31 . SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/theme/dawn/images/yifu4.png' LIMIT 1 [0.001301s/0.041036s=3.17%]
7/31 . SELECT * FROM `payment` WHERE `status` = '1' ORDER BY `weigh` DESC,`id` ASC [0.001223s/0.041036s=2.98%]
8/31 . SELECT `value` FROM `config` WHERE `name` = 'lang_auto_detect' LIMIT 1 [0.001223s/0.041036s=2.98%]
9/31 . SELECT * FROM `themes_menu_item` WHERE `themes_menu_item`.`deletetime` IS NULL [0.001220s/0.041036s=2.97%]
10/31 . SELECT `value` FROM `config` WHERE `name` = 'customer_login_config' LIMIT 1 [0.001220s/0.041036s=2.97%]
11/31 . SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/theme/dawn/images/yifu3.png' LIMIT 1 [0.001193s/0.041036s=2.91%]
12/31 . SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/theme/dawn/images/yifu2.png' LIMIT 1 [0.001193s/0.041036s=2.91%]
13/31 . SELECT `value` FROM `config` WHERE `name` = 'klaviyo_config' LIMIT 1 [0.001188s/0.041036s=2.90%]
14/31 . SELECT * FROM `category` [0.001188s/0.041036s=2.90%]
15/31 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('2',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.001159s/0.041036s=2.82%]
16/31 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('2',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.001148s/0.041036s=2.80%]
17/31 . SELECT `value` FROM `config` WHERE `name` = 'channel_google' LIMIT 1 [0.001140s/0.041036s=2.78%]
18/31 . SELECT * FROM `category` WHERE `id` = 0 AND `status` = 'normal' LIMIT 1 [0.001137s/0.041036s=2.77%]
19/31 . SELECT COUNT(*) AS tp_count FROM `app_center` WHERE `name` = 'access_control' AND `is_installed` = 1 LIMIT 1 [0.001112s/0.041036s=2.71%]
20/31 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('1',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.001105s/0.041036s=2.69%]
21/31 . 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.041036s=2.69%]
22/31 . SELECT `value` FROM `config` WHERE ( name = 'byIpSwitch' ) LIMIT 1 [0.001100s/0.041036s=2.68%]
23/31 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('1',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.001099s/0.041036s=2.68%]
24/31 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('1',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.001096s/0.041036s=2.67%]
25/31 . SELECT * FROM `category` [0.001095s/0.041036s=2.67%]
26/31 . set time_zone = '+08:00' [0.001061s/0.041036s=2.59%]
27/31 . 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.001050s/0.041036s=2.56%]
28/31 . SELECT `id` FROM `themes_onepage_store` WHERE `mode` = 1 AND `status` = 1 LIMIT 1 [0.001035s/0.041036s=2.52%]
29/31 . SELECT `value` FROM `config` WHERE ( name = 'multiCurrencySwitch' ) LIMIT 1 [0.001009s/0.041036s=2.46%]
30/31 . SELECT * FROM `category` [0.000998s/0.041036s=2.43%]
31/31 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('2',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.000904s/0.041036s=2.20%]
1/5. SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('2',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [3 times, 0.003211s/0.041036s=7.82%]
2/5. SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('1',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [3 times, 0.0033s/0.041036s=8.04%]
3/5. SELECT * FROM `category` WHERE `id` = 0 AND `status` = 'normal' LIMIT 1 [3 times, 0.006671s/0.041036s=16.26%]
4/5. SELECT * FROM `category` [3 times, 0.003281s/0.041036s=8.00%]
5/5. 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.002152s/0.041036s=5.24%]