[ DB ] CONNECT:[ UseTime:0.003855s ] mysql:host=database-test2.cb81pdkxodkj.us-east-1.rds.amazonaws.com:3306;port=3306;dbname=shoppaas_1705546782841;charset=utf8mb4
[ SQL ] SELECT COUNT(*) AS tp_count FROM `app_center` WHERE `name` = 'access_control' AND `is_installed` = 1 LIMIT 1 [ RunTime:0.001094s ]
[ SQL ] SELECT * FROM `payment` WHERE `status` = '1' ORDER BY `weigh` DESC,`id` ASC [ RunTime:0.001532s ]
[ SQL ] SELECT `value` FROM `config` WHERE `name` = 'channel_google' LIMIT 1 [ RunTime:0.004024s ]
[ SQL ] SELECT `value` FROM `config` WHERE `name` = 'lang_auto_detect' LIMIT 1 [ RunTime:0.001125s ]
[ SQL ] set time_zone = '+08:00' [ RunTime:0.001136s ]
[ SQL ] SELECT `value` FROM `config` WHERE ( name = 'multiCurrencySwitch' ) LIMIT 1 [ RunTime:0.001142s ]
[ SQL ] SELECT `value` FROM `config` WHERE ( name = 'byIpSwitch' ) LIMIT 1 [ RunTime:0.001227s ]
[ SQL ] SELECT `value` FROM `config` WHERE `name` = 'customer_login_config' LIMIT 1 [ RunTime:0.001345s ]
[ SQL ] SELECT * FROM `category` [ RunTime:0.001175s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('1',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.001452s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('2',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.001017s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('3',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.000991s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('4',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.001015s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('5',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.001135s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('6',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.000991s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `product` WHERE ( `status` = 'up' ) AND `product`.`deletetime` IS NULL LIMIT 1 [ RunTime:0.001025s ]
[ SQL ] SELECT `value` FROM `config` WHERE `name` = 'klaviyo_config' LIMIT 1 [ RunTime:0.001311s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `app_center` WHERE `name` = 'salesmartly' AND `is_installed` = 1 LIMIT 1 [ RunTime:0.001559s ]
[ SQL ] SELECT * FROM `themes_menu_item` WHERE `themes_menu_item`.`deletetime` IS NULL [ RunTime:0.001088s ]
[ 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.001622s ]
[ SQL ] SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/assets/shop/img/svg/no-image.svg' LIMIT 1 [ RunTime:0.001108s ]
[ 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.001019s ]
[ SQL ] SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/assets/shop/img/svg/no-image.svg' LIMIT 1 [ RunTime:0.001114s ]
[ SQL ] SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/assets/shop/img/svg/no-image.svg' LIMIT 1 [ RunTime:0.001198s ]
[ SQL ] SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/assets/shop/img/svg/no-image.svg' LIMIT 1 [ RunTime:0.001200s ]
[ SQL ] SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/assets/shop/img/svg/no-image.svg' LIMIT 1 [ RunTime:0.001163s ]
1/27 . SELECT `value` FROM `config` WHERE `name` = 'channel_google' LIMIT 1 [0.004024s/0.037663s=10.68%]
3/27 . 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.001622s/0.037663s=4.31%]
4/27 . SELECT COUNT(*) AS tp_count FROM `app_center` WHERE `name` = 'salesmartly' AND `is_installed` = 1 LIMIT 1 [0.001559s/0.037663s=4.14%]
5/27 . SELECT * FROM `payment` WHERE `status` = '1' ORDER BY `weigh` DESC,`id` ASC [0.001532s/0.037663s=4.07%]
6/27 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('1',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.001452s/0.037663s=3.86%]
7/27 . SELECT `value` FROM `config` WHERE `name` = 'customer_login_config' LIMIT 1 [0.001345s/0.037663s=3.57%]
8/27 . SELECT `value` FROM `config` WHERE `name` = 'klaviyo_config' LIMIT 1 [0.001311s/0.037663s=3.48%]
9/27 . SELECT `value` FROM `config` WHERE ( name = 'byIpSwitch' ) LIMIT 1 [0.001227s/0.037663s=3.26%]
10/27 . SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/assets/shop/img/svg/no-image.svg' LIMIT 1 [0.001200s/0.037663s=3.19%]
11/27 . SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/assets/shop/img/svg/no-image.svg' LIMIT 1 [0.001198s/0.037663s=3.18%]
12/27 . SELECT * FROM `category` [0.001175s/0.037663s=3.12%]
13/27 . SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/assets/shop/img/svg/no-image.svg' LIMIT 1 [0.001163s/0.037663s=3.09%]
14/27 . SELECT `value` FROM `config` WHERE ( name = 'multiCurrencySwitch' ) LIMIT 1 [0.001142s/0.037663s=3.03%]
15/27 . set time_zone = '+08:00' [0.001136s/0.037663s=3.02%]
16/27 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('5',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.001135s/0.037663s=3.01%]
17/27 . SELECT `value` FROM `config` WHERE `name` = 'lang_auto_detect' LIMIT 1 [0.001125s/0.037663s=2.99%]
18/27 . SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/assets/shop/img/svg/no-image.svg' LIMIT 1 [0.001114s/0.037663s=2.96%]
19/27 . SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/assets/shop/img/svg/no-image.svg' LIMIT 1 [0.001108s/0.037663s=2.94%]
20/27 . SELECT COUNT(*) AS tp_count FROM `app_center` WHERE `name` = 'access_control' AND `is_installed` = 1 LIMIT 1 [0.001094s/0.037663s=2.90%]
21/27 . SELECT * FROM `themes_menu_item` WHERE `themes_menu_item`.`deletetime` IS NULL [0.001088s/0.037663s=2.89%]
22/27 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( `status` = 'up' ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.001025s/0.037663s=2.72%]
23/27 . 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.001019s/0.037663s=2.71%]
24/27 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('2',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.001017s/0.037663s=2.70%]
25/27 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('4',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.001015s/0.037663s=2.69%]
26/27 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('3',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.000991s/0.037663s=2.63%]
27/27 . SELECT COUNT(*) AS tp_count FROM `product` WHERE ( ( find_in_set('6',category_ids) ) ) AND `product`.`deletetime` IS NULL LIMIT 1 [0.000991s/0.037663s=2.63%]
1/2. SELECT `imageheight`,`imagewidth` FROM `attachment` WHERE `url` = '/assets/shop/img/svg/no-image.svg' LIMIT 1 [5 times, 0.005783s/0.037663s=15.35%]
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.002641s/0.037663s=7.01%]