SHOW FULL COLUMNS FROM `sj_customer` [ RunTime:0.001006s ]
SELECT * FROM `sj_customer` WHERE ( `id` = 0 ) AND `sj_customer`.`del_time` = 0 LIMIT 1 [ RunTime:0.000410s ]
SHOW FULL COLUMNS FROM `sj_shop_mod` [ RunTime:0.000723s ]
SELECT `SM`.`id` FROM `sj_shop_mod` `SM` INNER JOIN `sj_mod_category` `MC` ON `MC`.`id`=`SM`.`index_cat_id` WHERE ( `app_type` = 1 AND `shop_id` = 170613328031256576 AND `type` = 2 ) AND `SM`.`del_time` = 0 LIMIT 1 [ RunTime:0.000399s ]
SHOW FULL COLUMNS FROM `sj_shop_mod_config` [ RunTime:0.000741s ]
SELECT id as mod_config_id,`title`,`sub_title`,`image`,`assistant_image`,`type`,`foreign_key`,`url`,`col`,`bg_color`,`more_url` FROM `sj_shop_mod_config` WHERE ( `shop_id` = 170613328031256576 AND `mod_id` = 83 AND `status` = 1 ) AND `sj_shop_mod_config`.`del_time` = 0 ORDER BY `sort` [ RunTime:0.000456s ]
SHOW FULL COLUMNS FROM `sj_category_nav` [ RunTime:0.000748s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 0 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000927s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1894 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000982s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1895 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000972s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1896 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001046s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1897 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001029s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1898 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000950s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1899 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000926s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1900 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000903s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1901 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000917s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1902 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000995s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1903 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000933s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 831 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000955s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 832 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000953s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1350 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000921s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1351 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000951s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1352 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000910s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1353 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000909s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1632 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000867s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1634 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000911s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 834 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000924s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1386 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000902s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1388 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000868s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1389 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000863s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1390 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000921s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1391 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000865s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1396 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000894s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1398 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000856s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1400 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000908s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1401 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000911s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1403 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000970s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1404 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000900s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1405 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000867s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1695 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000864s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1406 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000963s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1407 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000869s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1408 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000862s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1409 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000856s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1411 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000967s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1412 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001036s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1413 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000869s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1694 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000864s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1414 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001162s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1415 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000897s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1417 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001036s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1418 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000941s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1419 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000934s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1422 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000909s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1423 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000885s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1424 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000885s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 845 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000894s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1425 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000889s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1426 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000941s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1682 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000964s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1428 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000918s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1429 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000978s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1431 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000930s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1434 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000955s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1436 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000902s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1437 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000904s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1696 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001154s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 856 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000982s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 858 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000979s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1159 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000954s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1161 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000936s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1164 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001050s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1205 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000939s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1206 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000936s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1213 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000875s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1214 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000858s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1215 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000872s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1217 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000981s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1224 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000937s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 860 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000961s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1167 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001019s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1168 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000947s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1169 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000969s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1170 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000964s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1171 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001019s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1172 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001009s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1685 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001045s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1177 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001016s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 862 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001047s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 866 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000980s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 869 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001102s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1178 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000964s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1690 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001021s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1179 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001013s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1180 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000947s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1183 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001065s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1185 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001066s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 871 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001011s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1588 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001006s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1589 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001018s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1591 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001027s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1592 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000957s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1594 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001018s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1595 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000961s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1599 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001176s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1193 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001014s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1687 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000901s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1196 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000898s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1200 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000936s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1203 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000903s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1233 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000982s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1234 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001023s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1235 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000961s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1238 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000942s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1239 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000929s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1240 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000894s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 870 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000923s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1613 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000897s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1617 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000902s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1646 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000927s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1647 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000901s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1650 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001121s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1656 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000885s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1657 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000878s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1659 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000943s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1662 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000916s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1228 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001007s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1354 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000968s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1355 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001012s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1357 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000945s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1358 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000991s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1360 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000909s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1364 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000941s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1365 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000940s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1366 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000903s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1274 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000918s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1280 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000936s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1281 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000912s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1275 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000993s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1276 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000980s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1279 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001066s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1229 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001193s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 875 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001048s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1517 AND `status` = 1 ORDER BY `sort` [ RunTime:0.001146s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1520 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000985s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1522 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000926s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1492 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000933s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1493 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000931s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1495 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000909s ]
SELECT `id`,`title`,`type`,`url`,`param`,`image`,`icon`,`select_icon` FROM `sj_category_nav` WHERE `shop_id` = 170613328031256576 AND `client_type` = 1 AND `parent_id` = 1500 AND `status` = 1 ORDER BY `sort` [ RunTime:0.000909s ]
SHOW FULL COLUMNS FROM `sj_article_category` [ RunTime:0.000793s ]
SELECT `id`,`icon`,`name` FROM `sj_article_category` WHERE `shop_id` = 170613328031256576 AND `type` = 1 ORDER BY `sort` [ RunTime:0.000350s ]
SHOW FULL COLUMNS FROM `sj_article` [ RunTime:0.000865s ]
SELECT `id`,`title` FROM `sj_article` WHERE `shop_id` = 170613328031256576 AND `status` = 1 AND `category_id` = 6 ORDER BY `sort` [ RunTime:0.000363s ]
SELECT `id`,`title` FROM `sj_article` WHERE `shop_id` = 170613328031256576 AND `status` = 1 AND `category_id` = 7 ORDER BY `sort` [ RunTime:0.000435s ]
SELECT `id`,`title` FROM `sj_article` WHERE `shop_id` = 170613328031256576 AND `status` = 1 AND `category_id` = 8 ORDER BY `sort` [ RunTime:0.000332s ]
SELECT `id`,`title` FROM `sj_article` WHERE `shop_id` = 170613328031256576 AND `status` = 1 AND `category_id` = 9 ORDER BY `sort` [ RunTime:0.000462s ]
SELECT `id`,`title` FROM `sj_article` WHERE `shop_id` = 170613328031256576 AND `status` = 1 AND `category_id` = 10 ORDER BY `sort` [ RunTime:0.000382s ]
SHOW FULL COLUMNS FROM `sj_sensitive_word` [ RunTime:0.000635s ]
SELECT `sensitive_word` FROM `sj_sensitive_word` [ RunTime:0.000386s ]
SELECT `replace_word` FROM `sj_sensitive_word` [ RunTime:0.000321s ]
SHOW FULL COLUMNS FROM `sj_shop_auth_rule` [ RunTime:0.000736s ]
SELECT * FROM `sj_shop_auth_rule` WHERE `title` = 'Index/index' LIMIT 1 [ RunTime:0.000295s ]
SHOW FULL COLUMNS FROM `sj_option_log` [ RunTime:0.000663s ]
SELECT SM.id as mod_id,`type`,`title`,`sub_title`,`is_show_title`,`more_url`,`bg_color` FROM `sj_shop_mod` `SM` INNER JOIN `sj_mod_category` `MC` ON `SM`.`index_cat_id`=`MC`.`id` WHERE ( `SM`.`shop_id` = 170613328031256576 AND `SM`.`status` = 1 AND `MC`.`app_type` = 1 AND `MC`.`location_code` = 'index' ) AND `SM`.`del_time` = 0 ORDER BY `SM`.`sort` [ RunTime:0.000628s ]
SELECT id as mod_config_id,`title`,`sub_title`,`image`,`assistant_image`,`type`,`foreign_key`,`url`,`col`,`bg_color`,`more_url` FROM `sj_shop_mod_config` WHERE ( `shop_id` = 170613328031256576 AND `mod_id` = 82 AND `status` = 1 ) AND `sj_shop_mod_config`.`del_time` = 0 ORDER BY `sort` [ RunTime:0.000446s ]
SELECT id as mod_config_id,`title`,`sub_title`,`image`,`assistant_image`,`type`,`foreign_key`,`url`,`col`,`bg_color`,`more_url` FROM `sj_shop_mod_config` WHERE ( `shop_id` = 170613328031256576 AND `mod_id` = 89 AND `status` = 1 ) AND `sj_shop_mod_config`.`del_time` = 0 ORDER BY `sort` [ RunTime:0.000394s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 331 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000298s ]
SHOW FULL COLUMNS FROM `sj_customer_purchase_limitation` [ RunTime:0.002432s ]
SHOW FULL COLUMNS FROM `sj_shop_config` [ RunTime:0.000651s ]
SHOW FULL COLUMNS FROM `sj_freight_template` [ RunTime:0.000661s ]
SHOW FULL COLUMNS FROM `sj_full_reduction` [ RunTime:0.000629s ]
SHOW FULL COLUMNS FROM `sj_product` [ RunTime:0.000901s ]
SHOW FULL COLUMNS FROM `sj_product_category` [ RunTime:0.000601s ]
SHOW FULL COLUMNS FROM `sj_product_image` [ RunTime:0.000634s ]
SHOW FULL COLUMNS FROM `sj_product_attr` [ RunTime:0.000591s ]
SHOW FULL COLUMNS FROM `sj_product_sku` [ RunTime:0.000673s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('250003548643790848','250001365416284160','250005084220428288','250005053467791360','250005059771830272','250004822965620736') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000625s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('250003548643790848','250001365416284160','250005084220428288','250005053467791360','250005059771830272','250004822965620736') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000637s ]
SHOW FULL COLUMNS FROM `sj_supplier` [ RunTime:0.000728s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000508s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000291s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250001365416284160' [ RunTime:0.000312s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250001370944376832' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000329s ]
SHOW FULL COLUMNS FROM `sj_time_product` [ RunTime:0.000693s ]
SHOW FULL COLUMNS FROM `sj_time_product_version` [ RunTime:0.000623s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250001370944376832' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000347s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250003548643790848' [ RunTime:0.000352s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250003553949585408' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000353s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250003553949585408' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000300s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000456s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 332 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000281s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('250008167814008832','213058557145255936','213058903800287232','213058780177371136','213059034691932160','213059210299052032','213059216607285248') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000643s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('250008167814008832','213058557145255936','213058903800287232','213058780177371136','213059034691932160','213059210299052032','213059216607285248') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000727s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000442s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000320s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058903800287232' [ RunTime:0.000316s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058904232300544' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000304s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058904232300544' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000287s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059034691932160' [ RunTime:0.000340s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059035140722688' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000298s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059035140722688' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000322s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058557145255936' [ RunTime:0.000282s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058557564686336' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000294s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058557564686336' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000294s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250008167814008832' [ RunTime:0.000290s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250008173316935680' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000291s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250008173316935680' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000290s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059210299052032' [ RunTime:0.000303s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059210710093824' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000312s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059210710093824' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000310s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058780177371136' [ RunTime:0.000329s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058780550664192' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000309s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058780550664192' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000300s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000464s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 333 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000305s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('250001213519564800','250001219660025856','250001227474014208','250001234667245568','250001247992549376','250001254460166144','250007082923724800','213059350346862592','213059349688356864','213059348283265024','213059347817697280','213059343740833792','213059343271071744','213059342293798912','213059339353591808','213059338908995584','213059331413774336') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000823s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('250001213519564800','250001219660025856','250001227474014208','250001234667245568','250001247992549376','250001254460166144','250007082923724800','213059350346862592','213059349688356864','213059348283265024','213059347817697280','213059343740833792','213059343271071744','213059342293798912','213059339353591808','213059338908995584','213059331413774336') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000908s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000460s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000251s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059347817697280' [ RunTime:0.000323s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059348207767552' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000299s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059348207767552' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000307s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059339353591808' [ RunTime:0.000292s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059339747856384' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000289s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059339747856384' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000294s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250001234667245568' [ RunTime:0.000606s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250001240426024960' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000437s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250001240426024960' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000530s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250001219660025856' [ RunTime:0.000380s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250001226324774912' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000386s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250001226324774912' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000317s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059343740833792' [ RunTime:0.000338s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059344139292672' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000389s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059344139292672' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000377s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250001227474014208' [ RunTime:0.000484s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250001233740304384' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000371s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250001233740304384' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000361s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059338908995584' [ RunTime:0.000369s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059339299065856' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000379s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059339299065856' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000413s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250001213519564800' [ RunTime:0.000351s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250001218959577088' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000323s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250001218959577088' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000332s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250001254460166144' [ RunTime:0.000309s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250001260084727808' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000396s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250001260084727808' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000342s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059343271071744' [ RunTime:0.000360s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059343682113536' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000329s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059343682113536' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000383s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250001247992549376' [ RunTime:0.000335s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250001253730357248' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000292s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250001253730357248' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000329s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059349688356864' [ RunTime:0.000296s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059350221033472' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000285s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059350221033472' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000291s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059331413774336' [ RunTime:0.000278s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059331816427520' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000314s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059331816427520' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000272s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059350346862592' [ RunTime:0.000394s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059351298969600' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000318s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059351298969600' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000330s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059348283265024' [ RunTime:0.000288s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059348690112512' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000310s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059348690112512' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000298s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000441s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 334 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000290s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213059512184082432','213060441717346304','213060444858880000') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000472s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213059512184082432','213060441717346304','213060444858880000') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000686s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000449s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000274s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213060441717346304' [ RunTime:0.000315s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213060442153553920' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000292s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213060442153553920' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000314s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059512184082432' [ RunTime:0.000286s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059512628678656' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000294s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059512628678656' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000300s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213060444858880000' [ RunTime:0.000298s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213060445358002176' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000269s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213060445358002176' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000584s ]
SELECT id as mod_config_id,`title`,`sub_title`,`image`,`assistant_image`,`type`,`foreign_key`,`url`,`col`,`bg_color`,`more_url` FROM `sj_shop_mod_config` WHERE ( `shop_id` = 170613328031256576 AND `mod_id` = 119 AND `status` = 1 ) AND `sj_shop_mod_config`.`del_time` = 0 ORDER BY `sort` [ RunTime:0.000437s ]
SELECT id as mod_config_id,`title`,`sub_title`,`image`,`assistant_image`,`type`,`foreign_key`,`url`,`col`,`bg_color`,`more_url` FROM `sj_shop_mod_config` WHERE ( `shop_id` = 170613328031256576 AND `mod_id` = 121 AND `status` = 1 ) AND `sj_shop_mod_config`.`del_time` = 0 ORDER BY `sort` [ RunTime:0.000440s ]
SELECT id as mod_config_id,`title`,`sub_title`,`image`,`assistant_image`,`type`,`foreign_key`,`url`,`col`,`bg_color`,`more_url` FROM `sj_shop_mod_config` WHERE ( `shop_id` = 170613328031256576 AND `mod_id` = 83 AND `status` = 1 ) AND `sj_shop_mod_config`.`del_time` = 0 ORDER BY `sort` [ RunTime:0.000565s ]
SELECT id as mod_config_id,`title`,`sub_title`,`image`,`assistant_image`,`type`,`foreign_key`,`url`,`col`,`bg_color`,`more_url` FROM `sj_shop_mod_config` WHERE ( `shop_id` = 170613328031256576 AND `mod_id` = 126 AND `status` = 1 ) AND `sj_shop_mod_config`.`del_time` = 0 ORDER BY `sort` [ RunTime:0.000489s ]
SELECT id as mod_config_id,`title`,`sub_title`,`image`,`assistant_image`,`type`,`foreign_key`,`url`,`col`,`bg_color`,`more_url` FROM `sj_shop_mod_config` WHERE ( `shop_id` = 170613328031256576 AND `mod_id` = 97 AND `status` = 1 ) AND `sj_shop_mod_config`.`del_time` = 0 ORDER BY `sort` [ RunTime:0.000447s ]
SELECT id as mod_config_id,`title`,`sub_title`,`image`,`assistant_image`,`type`,`foreign_key`,`url`,`col`,`bg_color`,`more_url` FROM `sj_shop_mod_config` WHERE ( `shop_id` = 170613328031256576 AND `mod_id` = 85 AND `status` = 1 ) AND `sj_shop_mod_config`.`del_time` = 0 ORDER BY `sort` [ RunTime:0.000464s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 322 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000328s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('307309754399592448','269267792933425152','213059894457143296') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000711s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('307309754399592448','269267792933425152','213059894457143296') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000653s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000515s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000323s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '307309754399592448' [ RunTime:0.000351s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '307309754403786752' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000312s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '307309754403786752' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000341s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '269267792933425152' [ RunTime:0.000335s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '269267792937619456' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000354s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '269267792937619456' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000374s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059894457143296' [ RunTime:0.000370s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059894922711040' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000360s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059894922711040' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000474s ]
SELECT id as mod_config_id,`title`,`sub_title`,`image`,`assistant_image`,`type`,`foreign_key`,`url`,`col`,`bg_color`,`more_url` FROM `sj_shop_mod_config` WHERE ( `shop_id` = 170613328031256576 AND `mod_id` = 96 AND `status` = 1 ) AND `sj_shop_mod_config`.`del_time` = 0 ORDER BY `sort` [ RunTime:0.000519s ]
SELECT id as mod_config_id,`title`,`sub_title`,`image`,`assistant_image`,`type`,`foreign_key`,`url`,`col`,`bg_color`,`more_url` FROM `sj_shop_mod_config` WHERE ( `shop_id` = 170613328031256576 AND `mod_id` = 86 AND `status` = 1 ) AND `sj_shop_mod_config`.`del_time` = 0 ORDER BY `sort` [ RunTime:0.000409s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 323 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000355s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('269996880409137152','257619840255135744') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000518s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('269996880409137152','257619840255135744') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000589s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000492s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000311s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '257619840255135744' [ RunTime:0.000318s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '257619840271912960' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000316s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '257619840271912960' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000469s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 664 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000324s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` = '250006318381797376' AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000424s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` = '250006318381797376' AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000558s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000522s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000406s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250006318381797376' [ RunTime:0.000395s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '256841309132689408' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000399s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '256841309132689408' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000606s ]
SELECT id as mod_config_id,`title`,`sub_title`,`image`,`assistant_image`,`type`,`foreign_key`,`url`,`col`,`bg_color`,`more_url` FROM `sj_shop_mod_config` WHERE ( `shop_id` = 170613328031256576 AND `mod_id` = 122 AND `status` = 1 ) AND `sj_shop_mod_config`.`del_time` = 0 ORDER BY `sort` [ RunTime:0.000510s ]
SELECT id as mod_config_id,`title`,`sub_title`,`image`,`assistant_image`,`type`,`foreign_key`,`url`,`col`,`bg_color`,`more_url` FROM `sj_shop_mod_config` WHERE ( `shop_id` = 170613328031256576 AND `mod_id` = 87 AND `status` = 1 ) AND `sj_shop_mod_config`.`del_time` = 0 ORDER BY `sort` [ RunTime:0.000468s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 324 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000375s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213059379862179840','250002905019453440','250010049022267392','258393533453438976','310119668549423104','250010112779882496','250010876638138368','250001667716550656') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000912s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213059379862179840','250002905019453440','250010049022267392','258393533453438976','310119668549423104','250010112779882496','250010876638138368','250001667716550656') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000952s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000588s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000337s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250010876638138368' [ RunTime:0.000368s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250010882044596224' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000345s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250010882044596224' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000400s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250002905019453440' [ RunTime:0.000331s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250002910295887872' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000347s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250002910295887872' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000370s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059379862179840' [ RunTime:0.000324s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059380394856448' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000345s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059380394856448' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000322s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250010049022267392' [ RunTime:0.000330s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250010054667800576' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000389s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250010054667800576' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000460s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '258393533453438976' [ RunTime:0.000423s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '258393533461827584' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000398s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '258393533461827584' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000537s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000567s ]
SELECT id as mod_config_id,`title`,`sub_title`,`image`,`assistant_image`,`type`,`foreign_key`,`url`,`col`,`bg_color`,`more_url` FROM `sj_shop_mod_config` WHERE ( `shop_id` = 170613328031256576 AND `mod_id` = 124 AND `status` = 1 ) AND `sj_shop_mod_config`.`del_time` = 0 ORDER BY `sort` [ RunTime:0.000570s ]
SELECT id as mod_config_id,`title`,`sub_title`,`image`,`assistant_image`,`type`,`foreign_key`,`url`,`col`,`bg_color`,`more_url` FROM `sj_shop_mod_config` WHERE ( `shop_id` = 170613328031256576 AND `mod_id` = 84 AND `status` = 1 ) AND `sj_shop_mod_config`.`del_time` = 0 ORDER BY `sort` [ RunTime:0.000442s ]
SELECT id as mod_config_id,`title`,`sub_title`,`image`,`assistant_image`,`type`,`foreign_key`,`url`,`col`,`bg_color`,`more_url` FROM `sj_shop_mod_config` WHERE ( `shop_id` = 170613328031256576 AND `mod_id` = 88 AND `status` = 1 ) AND `sj_shop_mod_config`.`del_time` = 0 ORDER BY `sort` [ RunTime:0.000493s ]
SHOW FULL COLUMNS FROM `sj_coupon` [ RunTime:0.000947s ]
SHOW FULL COLUMNS FROM `sj_customer_coupon` [ RunTime:0.000682s ]
SHOW FULL COLUMNS FROM `sj_use_coupon` [ RunTime:0.000587s ]
SELECT id as mod_config_id,`title`,`sub_title`,`image`,`assistant_image`,`type`,`foreign_key`,`url`,`col`,`bg_color`,`more_url` FROM `sj_shop_mod_config` WHERE ( `shop_id` = 170613328031256576 AND `mod_id` = 90 AND `status` = 1 ) AND `sj_shop_mod_config`.`del_time` = 0 ORDER BY `sort` [ RunTime:0.000435s ]
SELECT * FROM `sj_coupon` WHERE ( `id` = 6 AND `status` = 1 ) AND `sj_coupon`.`del_time` = 0 [ RunTime:0.000312s ]
SELECT * FROM `sj_coupon` WHERE ( `id` = 7 AND `status` = 1 ) AND `sj_coupon`.`del_time` = 0 [ RunTime:0.000292s ]
SELECT * FROM `sj_coupon` WHERE ( `id` = 3 AND `status` = 1 ) AND `sj_coupon`.`del_time` = 0 [ RunTime:0.000399s ]
SELECT id as mod_config_id,`title`,`sub_title`,`image`,`assistant_image`,`type`,`foreign_key`,`url`,`col`,`bg_color`,`more_url` FROM `sj_shop_mod_config` WHERE ( `shop_id` = 170613328031256576 AND `mod_id` = 92 AND `status` = 1 ) AND `sj_shop_mod_config`.`del_time` = 0 ORDER BY `sort` [ RunTime:0.000526s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 342 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000306s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213058320137719808','213058320641036288','250002409722482688','250011409578987520','213059215667761152','213059214166200320') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000785s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213058320137719808','213058320641036288','250002409722482688','250011409578987520','213059215667761152','213059214166200320') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000898s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000643s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000374s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058320137719808' [ RunTime:0.000415s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058320582316032' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000399s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058320582316032' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000347s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059214166200320' [ RunTime:0.000390s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059214585630720' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000354s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059214585630720' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000496s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059215667761152' [ RunTime:0.000384s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059216074608640' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000368s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059216074608640' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000357s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058320641036288' [ RunTime:0.000358s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058321052078080' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000475s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058321052078080' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000480s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 343 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000325s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('237252991659282432','237011949647302656','237009549456838656','237009627055656960','237252943265402880','237199412701433856','237023400499875840') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000810s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('237252991659282432','237011949647302656','237009549456838656','237009627055656960','237252943265402880','237199412701433856','237023400499875840') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000739s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000534s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000290s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000594s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 486 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000399s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('237304244384829440','237304218283675648','237202073794383872','250010423644917760','250010074582355968','250009998971637760','250004441413980160','250002311978422272','250002300007878656','237118204172832768','213059283439325184','213059167676534784','213059093542211584') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000803s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('237304244384829440','237304218283675648','237202073794383872','250010423644917760','250010074582355968','250009998971637760','250004441413980160','250002311978422272','250002300007878656','237118204172832768','213059283439325184','213059167676534784','213059093542211584') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000827s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000548s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000438s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250009998971637760' [ RunTime:0.000396s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250010004101271552' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000384s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250010004101271552' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000360s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250004441413980160' [ RunTime:0.000333s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250004446690414592' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000355s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250004446690414592' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000363s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059167676534784' [ RunTime:0.000333s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059168070799360' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000331s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059168070799360' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000301s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059283439325184' [ RunTime:0.000300s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059283825201152' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000317s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059283825201152' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000310s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059093542211584' [ RunTime:0.000343s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059093944864768' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000314s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059093944864768' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000486s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 487 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000361s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('237010559474601984','237010555364184064','237010535965528064','237007604042174464','237007599856259072','237004428580753408','237003745492209664','213059256482533376','213058443353788416','213058441894170624','250009942503723008','250009935750893568','250009922350092288','250001680601452544','250001674234499072','250001667716550656','250001661471232000') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000821s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('237010559474601984','237010555364184064','237010535965528064','237007604042174464','237007599856259072','237004428580753408','237003745492209664','213059256482533376','213058443353788416','213058441894170624','250009942503723008','250009935750893568','250009922350092288','250001680601452544','250001674234499072','250001667716550656','250001661471232000') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000992s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000541s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000458s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250001674234499072' [ RunTime:0.000552s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250001679968112640' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000434s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250001679968112640' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000398s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059256482533376' [ RunTime:0.000413s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059256872603648' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000432s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059256872603648' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000391s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058443353788416' [ RunTime:0.000350s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058443727081472' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000428s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058443727081472' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000376s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250009942503723008' [ RunTime:0.000430s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250009948308639744' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000393s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250009948308639744' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000406s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250009922350092288' [ RunTime:0.000385s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250009928222117888' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000388s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250009928222117888' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000376s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250009935750893568' [ RunTime:0.000391s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250009941723582464' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000434s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250009941723582464' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000339s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058441894170624' [ RunTime:0.000424s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058442280046592' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000500s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058442280046592' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000442s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250001661471232000' [ RunTime:0.000449s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250001666886078464' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000375s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250001666886078464' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000731s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 488 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000392s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('5743','237029532391968768','237029527467855872','237029233698803712','237027383100575744','213059591087329280','213059536066449408','213058736552415232','213058736103624704','213058735638056960') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000980s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('5743','237029532391968768','237029527467855872','237029233698803712','237027383100575744','213059591087329280','213059536066449408','213058736552415232','213058736103624704','213058735638056960') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.001100s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000692s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000336s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059536066449408' [ RunTime:0.000455s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059536506851328' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000429s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059536506851328' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000459s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059591087329280' [ RunTime:0.000379s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059591510953984' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000395s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059591510953984' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000374s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058736552415232' [ RunTime:0.000355s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058736992817152' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000401s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058736992817152' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000375s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058736103624704' [ RunTime:0.000358s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058736489500672' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000360s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058736489500672' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000368s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058735638056960' [ RunTime:0.000362s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058736044904448' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000353s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058736044904448' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000509s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 489 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000387s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('5736','213060813596921856','213060813068439552','213059304519897088','213059191307243520','213059168611864576','213059135904681984','213059135460085760','213058513029566464') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000802s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('5736','213060813596921856','213060813068439552','213059304519897088','213059191307243520','213059168611864576','213059135904681984','213059135460085760','213058513029566464') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000915s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000494s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000315s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213060813068439552' [ RunTime:0.000492s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213060813542395904' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000563s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213060813542395904' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000451s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213060813596921856' [ RunTime:0.000391s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213060814075072512' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000351s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213060814075072512' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000364s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059135904681984' [ RunTime:0.000368s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059136282169344' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000346s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059136282169344' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000464s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058513029566464' [ RunTime:0.000356s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058513444802560' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000330s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058513444802560' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000401s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059168611864576' [ RunTime:0.000322s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059169035489280' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000325s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059169035489280' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000518s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059135460085760' [ RunTime:0.000363s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059135845961728' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000377s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059135845961728' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000358s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059304519897088' [ RunTime:0.000380s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059304926744576' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000314s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059304926744576' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000384s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059191307243520' [ RunTime:0.000350s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059191730868224' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000382s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059191730868224' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000490s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 490 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000400s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('5956','237186312774356992','237022311184601088','237022306671529984','237016468040978432','237016463771176960','237012684720050176','237009618646077440','237009195352723456','237009191267471360','237009186880229376') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000800s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('5956','237186312774356992','237022311184601088','237022306671529984','237016468040978432','237016463771176960','237012684720050176','237009618646077440','237009195352723456','237009191267471360','237009186880229376') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000750s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000524s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000283s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000535s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 491 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000366s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('6068','250010119125864448','250010080714428416','250010036699402240','250002329779048448','250002323932188672','250002317917556736','250001642655584256','237291292260831232','237290820191916032','237290802575839232') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000764s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('6068','250010119125864448','250010080714428416','250010036699402240','250002329779048448','250002323932188672','250002317917556736','250001642655584256','237291292260831232','237290820191916032','237290802575839232') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000799s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000564s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000281s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250010036699402240' [ RunTime:0.000332s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250010042156191744' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000305s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250010042156191744' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000350s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250010080714428416' [ RunTime:0.000311s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250010086255104000' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000345s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250010086255104000' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000496s ]
SELECT id as mod_config_id,`title`,`sub_title`,`image`,`assistant_image`,`type`,`foreign_key`,`url`,`col`,`bg_color`,`more_url` FROM `sj_shop_mod_config` WHERE ( `shop_id` = 170613328031256576 AND `mod_id` = 91 AND `status` = 1 ) AND `sj_shop_mod_config`.`del_time` = 0 ORDER BY `sort` [ RunTime:0.000466s ]
SELECT id as mod_config_id,`title`,`sub_title`,`image`,`assistant_image`,`type`,`foreign_key`,`url`,`col`,`bg_color`,`more_url` FROM `sj_shop_mod_config` WHERE ( `shop_id` = 170613328031256576 AND `mod_id` = 93 AND `status` = 1 ) AND `sj_shop_mod_config`.`del_time` = 0 ORDER BY `sort` [ RunTime:0.000446s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 344 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000326s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('250007672357654528','250007665390915584','250007658231238656','237172783396687872','213059346425188352','213059345686990848','213059341756928000') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000834s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('250007672357654528','250007665390915584','250007658231238656','237172783396687872','213059346425188352','213059345686990848','213059341756928000') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000908s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000559s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000343s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059345686990848' [ RunTime:0.000344s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059346328719360' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000352s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059346328719360' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000372s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059346425188352' [ RunTime:0.000377s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059347050139648' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000426s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059347050139648' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000341s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250007658231238656' [ RunTime:0.000388s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250007663943880704' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000352s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250007663943880704' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000407s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250007672357654528' [ RunTime:0.000327s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250007677931884544' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000473s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250007677931884544' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000395s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059341756928000' [ RunTime:0.000339s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059342205718528' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000384s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059342205718528' AND `end_time` > 1728374186 AND `start_time` <= 1728374186 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000333s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250007665390915584' [ RunTime:0.000327s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250007670914813952' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000331s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250007670914813952' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000500s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 345 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000352s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213059342767755264','250007127358181376','250007120978644992','250001319044059136','250001195068821504','237239791110852608','237026130865950720','237016459346186240','213059349206011904','213059348753027072') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000852s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213059342767755264','250007127358181376','250007120978644992','250001319044059136','250001195068821504','237239791110852608','237026130865950720','237016459346186240','213059349206011904','213059348753027072') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000831s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000517s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000364s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250001195068821504' [ RunTime:0.000443s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250001200538193920' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000366s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250001200538193920' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000442s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059348753027072' [ RunTime:0.000459s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059349151485952' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000385s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059349151485952' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000402s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059349206011904' [ RunTime:0.000344s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059349625442304' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000357s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059349625442304' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000328s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250007120978644992' [ RunTime:0.000381s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250007126519320576' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000341s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250007126519320576' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000359s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250001319044059136' [ RunTime:0.000345s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250001325859803136' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000351s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250001325859803136' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000449s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250007127358181376' [ RunTime:0.000373s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250007132965965824' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000336s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250007132965965824' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000393s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059342767755264' [ RunTime:0.000413s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059343212351488' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000383s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059343212351488' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000520s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 417 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000395s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213058556583219200','213058557145255936','213059245698977792','213059412502253568','237111906832224256') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000727s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213058556583219200','213058557145255936','213059245698977792','213059412502253568','237111906832224256') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000731s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000484s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000347s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059245698977792' [ RunTime:0.000397s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059246101630976' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000339s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059246101630976' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000359s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058557145255936' [ RunTime:0.000367s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058557564686336' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000347s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058557564686336' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000357s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058556583219200' [ RunTime:0.000372s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058557002649600' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000394s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058557002649600' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000406s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059412502253568' [ RunTime:0.000421s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059412959432704' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000428s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059412959432704' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000552s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 493 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000450s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('237132572742651904','250008284252082176','250008291495645184','213060274637246464') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000683s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('237132572742651904','250008284252082176','250008291495645184','213060274637246464') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.001019s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000685s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000392s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213060274637246464' [ RunTime:0.000428s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213060275056676864' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000393s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213060275056676864' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000424s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250008291495645184' [ RunTime:0.000432s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250008296965017600' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000402s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250008296965017600' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000342s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250008284252082176' [ RunTime:0.000497s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250008290321240064' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000360s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250008290321240064' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000469s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 494 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000359s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213058647356346368','213060442208079872','213060496281047040','250001480965165056') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000620s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213058647356346368','213060442208079872','213060496281047040','250001480965165056') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000654s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000533s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000370s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213060442208079872' [ RunTime:0.000446s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213060442635898880' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000384s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213060442635898880' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000396s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213060496281047040' [ RunTime:0.000350s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213060496713060352' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000416s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213060496713060352' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000424s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058647356346368' [ RunTime:0.000366s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058647750610944' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000356s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058647750610944' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000497s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 495 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000384s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213060441717346304','213060494045483008','213060497811968000','250003421271166976') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000615s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213060441717346304','213060494045483008','213060497811968000','250003421271166976') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000821s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000553s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000313s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250003421271166976' [ RunTime:0.000343s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250003426455326720' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000369s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250003426455326720' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000334s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213060497811968000' [ RunTime:0.000367s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213060498277535744' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000342s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213060498277535744' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000337s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213060441717346304' [ RunTime:0.000469s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213060442153553920' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000452s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213060442153553920' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000472s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213060494045483008' [ RunTime:0.000346s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213060494565576704' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000318s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213060494565576704' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000556s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 496 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000361s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213058667111518208','250004142561431552','250003403139190784','250003330451902464','250003324131086336','250001351470223360','213060495672872960','213059371716841472') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000892s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213058667111518208','250004142561431552','250003403139190784','250003330451902464','250003324131086336','250001351470223360','213060495672872960','213059371716841472') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000918s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000528s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000322s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250003330451902464' [ RunTime:0.000321s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250003335594119168' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000431s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250003335594119168' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000322s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250003324131086336' [ RunTime:0.000348s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250003329436880896' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000303s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250003329436880896' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000360s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250003403139190784' [ RunTime:0.000302s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250003408319156224' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000324s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250003408319156224' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000322s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058667111518208' [ RunTime:0.000427s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058667476422656' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000434s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058667476422656' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000345s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250004142561431552' [ RunTime:0.000358s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250004147858837504' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000349s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250004147858837504' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000396s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213060495672872960' [ RunTime:0.000406s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213060496088109056' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000402s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213060496088109056' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000532s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 497 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000378s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213060859637796864','213060724023365632','213060723469717504') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000719s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213060859637796864','213060724023365632','213060723469717504') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000719s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000466s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000314s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213060724023365632' [ RunTime:0.000401s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213060724476350464' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000327s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213060724476350464' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000349s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213060723469717504' [ RunTime:0.000352s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213060723918508032' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000387s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213060723918508032' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000348s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213060859637796864' [ RunTime:0.000342s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213060860208222208' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000351s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213060860208222208' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000502s ]
SELECT id as mod_config_id,`title`,`sub_title`,`image`,`assistant_image`,`type`,`foreign_key`,`url`,`col`,`bg_color`,`more_url` FROM `sj_shop_mod_config` WHERE ( `shop_id` = 170613328031256576 AND `mod_id` = 99 AND `status` = 1 ) AND `sj_shop_mod_config`.`del_time` = 0 ORDER BY `sort` [ RunTime:0.000468s ]
SELECT id as mod_config_id,`title`,`sub_title`,`image`,`assistant_image`,`type`,`foreign_key`,`url`,`col`,`bg_color`,`more_url` FROM `sj_shop_mod_config` WHERE ( `shop_id` = 170613328031256576 AND `mod_id` = 94 AND `status` = 1 ) AND `sj_shop_mod_config`.`del_time` = 0 ORDER BY `sort` [ RunTime:0.000451s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 346 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000373s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213059387764248576','213059415878668288','213059416340041728','213059416902078464','213059417338286080') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000705s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213059387764248576','213059415878668288','213059416340041728','213059416902078464','213059417338286080') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000733s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000489s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000328s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059417338286080' [ RunTime:0.000335s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059417757716480' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000349s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059417757716480' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000485s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059416340041728' [ RunTime:0.000394s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059416759472128' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000353s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059416759472128' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000410s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059416902078464' [ RunTime:0.000418s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059417262788608' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000372s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059417262788608' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000402s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059415878668288' [ RunTime:0.000404s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059416277127168' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000348s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059416277127168' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000400s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059387764248576' [ RunTime:0.000341s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059388158513152' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000423s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059388158513152' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000315s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000487s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 480 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000355s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213059415379546112','213059414918172672','258393533453438976','258393197154144256') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000735s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213059415379546112','213059414918172672','258393533453438976','258393197154144256') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000706s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000622s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000332s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '258393197154144256' [ RunTime:0.000387s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '258393197158338560' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000316s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '258393197158338560' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000415s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059415379546112' [ RunTime:0.000356s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059415807365120' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000507s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059415807365120' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000719s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059414918172672' [ RunTime:0.000479s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059415316631552' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000387s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059415316631552' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000439s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '258393533453438976' [ RunTime:0.000369s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '258393533461827584' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000338s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '258393533461827584' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000532s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 481 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000341s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213059418357501952','213059417866768384','258398494568484864','258399766143045632') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000659s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213059418357501952','213059417866768384','258398494568484864','258399766143045632') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000603s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000603s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000493s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '258399766143045632' [ RunTime:0.000382s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '258399766147239936' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000610s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '258399766147239936' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000441s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059417866768384' [ RunTime:0.000459s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059418294587392' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000365s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059418294587392' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000394s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059418357501952' [ RunTime:0.000393s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059418785320960' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000371s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059418785320960' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000474s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 499 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000672s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213059410145054720','213059419829702656','258297061139550208','213059419359940608') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000679s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213059410145054720','213059419829702656','258297061139550208','213059419359940608') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000761s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000607s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000386s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059419829702656' [ RunTime:0.000354s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059420219772928' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000303s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059420219772928' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000372s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059410145054720' [ RunTime:0.000460s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059410547707904' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000634s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059410547707904' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000461s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059419359940608' [ RunTime:0.000640s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059419758399488' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000621s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059419758399488' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000512s ]
SELECT id as mod_config_id,`title`,`sub_title`,`image`,`assistant_image`,`type`,`foreign_key`,`url`,`col`,`bg_color`,`more_url` FROM `sj_shop_mod_config` WHERE ( `shop_id` = 170613328031256576 AND `mod_id` = 95 AND `status` = 1 ) AND `sj_shop_mod_config`.`del_time` = 0 ORDER BY `sort` [ RunTime:0.000624s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 347 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000415s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('250003601118728192','250003616834785280','250006052093825024','250006065289105408','250006259414077440') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000870s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('250003601118728192','250003616834785280','250006052093825024','250006065289105408','250006259414077440') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000813s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000585s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000487s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250006259414077440' [ RunTime:0.000517s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '256841551144030208' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000353s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '256841551144030208' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000361s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250003601118728192' [ RunTime:0.000440s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250003608060301312' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000384s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250003608060301312' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000483s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250006052093825024' [ RunTime:0.000492s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250006058137817088' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000522s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250006058137817088' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000493s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250003616834785280' [ RunTime:0.000467s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250003622195105792' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000470s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250003622195105792' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000456s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 449 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000471s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213059408781905920','250002584696262656','250006196352716800','250006265982357504','250011542467121152','250011548662108160','250011554559299584') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000903s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213059408781905920','250002584696262656','250006196352716800','250006265982357504','250011542467121152','250011548662108160','250011554559299584') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000917s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000596s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000388s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250002584696262656' [ RunTime:0.000424s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250002591847550976' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000394s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250002591847550976' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000594s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 503 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000469s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('250002025712979968','250002031987658752','250003199803527168','250004510502555648','250004517649649664') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000848s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('250002025712979968','250002031987658752','250003199803527168','250004510502555648','250004517649649664') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.001084s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000743s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000366s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250004510502555648' [ RunTime:0.000521s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250004516831760384' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000474s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250004516831760384' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000485s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250004517649649664' [ RunTime:0.000536s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250004524427644928' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000339s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250004524427644928' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000389s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250002025712979968' [ RunTime:0.000417s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250002031333347328' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000493s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250002031333347328' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000508s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250002031987658752' [ RunTime:0.000480s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250002037461225472' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000416s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250002037461225472' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000483s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250003199803527168' [ RunTime:0.000477s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250003205327425536' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000517s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250003205327425536' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000492s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 504 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000318s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213059432236453888','213059432798490624','213059433280835584','213059433754791936','250004608728961024') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000837s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213059432236453888','213059432798490624','213059433280835584','213059433754791936','250004608728961024') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000799s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000527s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000374s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059433754791936' [ RunTime:0.000484s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059434178416640' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000520s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059434178416640' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000418s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250004608728961024' [ RunTime:0.000371s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '262749984703647744' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000340s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '262749984703647744' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000478s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059433280835584' [ RunTime:0.000523s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059433687683072' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000434s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059433687683072' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000490s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059432236453888' [ RunTime:0.000364s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059432651689984' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000411s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059432651689984' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000503s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059432798490624' [ RunTime:0.000418s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059433196949504' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000415s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059433196949504' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000546s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 505 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000535s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('250006432185847808','250011505867624448','250011518270181376','250011530672738304','250011536674787328','250011644099301376','250011689326481408') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000875s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('250006432185847808','250011505867624448','250011518270181376','250011530672738304','250011536674787328','250011644099301376','250011689326481408') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.001436s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000840s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000293s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250011644099301376' [ RunTime:0.000318s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250011649501564928' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000458s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250011649501564928' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000385s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250011518270181376' [ RunTime:0.000402s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250011523689222144' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000356s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250011523689222144' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000322s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250011689326481408' [ RunTime:0.000416s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250011694871351296' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000395s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250011694871351296' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000560s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250011536674787328' [ RunTime:0.000521s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250011541674397696' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000486s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250011541674397696' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000429s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250006432185847808' [ RunTime:0.000456s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250006437671997440' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000357s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250006437671997440' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000391s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250011530672738304' [ RunTime:0.000438s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250011535886258176' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000437s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250011535886258176' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000594s ]
SELECT id as mod_config_id,`title`,`sub_title`,`image`,`assistant_image`,`type`,`foreign_key`,`url`,`col`,`bg_color`,`more_url` FROM `sj_shop_mod_config` WHERE ( `shop_id` = 170613328031256576 AND `mod_id` = 123 AND `status` = 1 ) AND `sj_shop_mod_config`.`del_time` = 0 ORDER BY `sort` [ RunTime:0.000627s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 419 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000371s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213059892464848896','213059892922028032','213059893467287552','213059894004158464','213059894457143296','213060697725079552','213060698253561856','213060698744295424','213060699247611904','237108385089064960','237108512121950208','237109089379815424','237240768572428288') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000870s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213059892464848896','213059892922028032','213059893467287552','213059894004158464','213059894457143296','213060697725079552','213060698253561856','213060698744295424','213060699247611904','237108385089064960','237108512121950208','237109089379815424','237240768572428288') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.001085s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000481s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000284s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059892464848896' [ RunTime:0.000490s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059892867502080' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000442s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059892867502080' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000405s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213060697725079552' [ RunTime:0.000497s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213060698194841600' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000415s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213060698194841600' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000436s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213060699247611904' [ RunTime:0.000443s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213060699700596736' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000346s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213060699700596736' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000444s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213060698744295424' [ RunTime:0.000442s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213060699193085952' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000373s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213060699193085952' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000434s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059892922028032' [ RunTime:0.000385s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059893391790080' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000442s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059893391790080' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000466s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059894457143296' [ RunTime:0.000399s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059894922711040' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000365s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059894922711040' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000325s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213060698253561856' [ RunTime:0.000417s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213060698689769472' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000433s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213060698689769472' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000429s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059894004158464' [ RunTime:0.000414s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059894398423040' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000348s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059894398423040' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000536s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059893467287552' [ RunTime:0.000420s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059893941243904' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000469s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059893941243904' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000679s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000627s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 482 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000444s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213058528791760896','213058961232891904','213059295611195392','213059296085151744') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000709s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213058528791760896','213058961232891904','213059295611195392','213059296085151744') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.001131s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000711s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000420s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000665s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 483 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000472s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('250004017759916032','237228704852348928','213060123701022720','213059049011286016') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000818s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('250004017759916032','237228704852348928','213060123701022720','213059049011286016') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000766s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000727s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000473s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059049011286016' [ RunTime:0.000404s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059049460076544' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000392s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059049460076544' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000400s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213060123701022720' [ RunTime:0.000393s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213060124174979072' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000314s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213060124174979072' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000711s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 506 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000466s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('250002421449756672','250001140467372032','213058754063634432','213058565684858880','250002487459713024','250002464026136576') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000861s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('250002421449756672','250001140467372032','213058754063634432','213058565684858880','250002487459713024','250002464026136576') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.001229s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000564s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000463s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250002464026136576' [ RunTime:0.000429s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250002469193519104' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000349s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250002469193519104' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000365s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250002487459713024' [ RunTime:0.000302s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250002492673232896' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000337s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250002492673232896' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000439s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250002421449756672' [ RunTime:0.000414s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250002427003015168' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000357s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250002427003015168' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000337s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058754063634432' [ RunTime:0.000449s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058754432733184' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000370s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058754432733184' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000368s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058565684858880' [ RunTime:0.000381s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058566028791808' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000473s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058566028791808' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000703s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 507 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000374s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('250002493373681664','250002517105053696') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000713s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('250002493373681664','250002517105053696') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000839s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000630s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000338s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250002517105053696' [ RunTime:0.000667s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250002522813501440' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000622s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250002522813501440' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000392s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250002493373681664' [ RunTime:0.000401s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250002498612367360' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000544s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250002498612367360' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000708s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 508 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000453s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213058511628668928','213058518981283840','213058752629182464','250003149958418432') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000926s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213058511628668928','213058518981283840','213058752629182464','250003149958418432') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000966s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000631s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000372s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058511628668928' [ RunTime:0.000359s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058511985184768' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000345s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058511985184768' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000515s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058518981283840' [ RunTime:0.000331s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058519371354112' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000619s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058519371354112' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000404s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058752629182464' [ RunTime:0.000355s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058753115721728' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000346s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058753115721728' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000673s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 509 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000632s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213059299956494336','213059293958639616','213058753619038208','213058609787965440','213058565202513920','213060679932841984','250001106690641920','237029512330612736','250001127372754944','250003088125988864') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000651s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213059299956494336','213059293958639616','213058753619038208','213058609787965440','213058565202513920','213060679932841984','250001106690641920','237029512330612736','250001127372754944','250003088125988864') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000816s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000471s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000292s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213060679932841984' [ RunTime:0.000320s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213060680436158464' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000339s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213060680436158464' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000305s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250003088125988864' [ RunTime:0.000333s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '261993293951275008' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000304s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '261993293951275008' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000326s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058609787965440' [ RunTime:0.000642s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058610320642048' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000389s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058610320642048' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000607s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059293958639616' [ RunTime:0.000472s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059294424207360' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000558s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059294424207360' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000438s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058753619038208' [ RunTime:0.000318s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058754004914176' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000418s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058754004914176' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000344s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058565202513920' [ RunTime:0.000342s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058565609361408' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000487s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058565609361408' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000550s ]
SELECT id as mod_config_id,`title`,`sub_title`,`image`,`assistant_image`,`type`,`foreign_key`,`url`,`col`,`bg_color`,`more_url` FROM `sj_shop_mod_config` WHERE ( `shop_id` = 170613328031256576 AND `mod_id` = 125 AND `status` = 1 ) AND `sj_shop_mod_config`.`del_time` = 0 ORDER BY `sort` [ RunTime:0.000777s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 425 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000355s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213058737554853888','213060462269435904','237012786096377856','237013432434429952','237012776755662848','237013427975884800') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000938s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213058737554853888','213060462269435904','237012786096377856','237013432434429952','237012776755662848','237013427975884800') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000855s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000595s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000365s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213060462269435904' [ RunTime:0.000402s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213060462722420736' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000334s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213060462722420736' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000336s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058737554853888' [ RunTime:0.000302s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058737949118464' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000305s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058737949118464' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000303s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000790s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 513 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000329s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213058744223797248','213058744760668160','237104309978796032','237105565828911104','237266249594179584','237266258205085696','237266266623053824','237105325927305216','237105312799133696','237102072636379136') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000632s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213058744223797248','213058744760668160','237104309978796032','237105565828911104','237266249594179584','237266258205085696','237266266623053824','237105325927305216','237105312799133696','237102072636379136') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000715s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000522s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000350s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058744760668160' [ RunTime:0.000374s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058745213652992' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000411s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058745213652992' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000364s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058744223797248' [ RunTime:0.000472s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058744680976384' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000524s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058744680976384' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000468s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000535s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 514 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000504s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213059027888771072','213059028350144512','213059028803129344','213059029247725568','213059029734264832','213059030375993344','213059304985464832','213060509799288832','213060510331965440','237287769905303552') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.001038s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213059027888771072','213059028350144512','213059028803129344','213059029247725568','213059029734264832','213059030375993344','213059304985464832','213060509799288832','213060510331965440','237287769905303552') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000781s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000467s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000275s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213060509799288832' [ RunTime:0.000719s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213060510277439488' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000392s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213060510277439488' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000751s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059304985464832' [ RunTime:0.000528s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059305379729408' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000490s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059305379729408' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000552s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059030375993344' [ RunTime:0.000666s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059030870921216' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000389s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059030870921216' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000461s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059028350144512' [ RunTime:0.000570s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059028736020480' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000411s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059028736020480' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000454s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059029247725568' [ RunTime:0.000401s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059029654573056' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000390s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059029654573056' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000468s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059027888771072' [ RunTime:0.000432s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059028270452736' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000330s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059028270452736' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000520s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059028803129344' [ RunTime:0.000382s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059029168033792' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000359s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059029168033792' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000329s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213060510331965440' [ RunTime:0.000326s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213060510873030656' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000335s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213060510873030656' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000338s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213059029734264832' [ RunTime:0.000533s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213059030317273088' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000426s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213059030317273088' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000495s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 485 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000331s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('237731746689323008','237731698396106752','237731679228137472','237138490347753472','237138483515232256','237138243471020032') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000889s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('237731746689323008','237731698396106752','237731679228137472','237138490347753472','237138483515232256','237138243471020032') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000930s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000517s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000429s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000597s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 511 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000340s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('237013601645236224','237013597316714496','237013540286763008','237013513921368064','237013631890362368','237013636365684736') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.000582s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('237013601645236224','237013597316714496','237013540286763008','237013513921368064','237013631890362368','237013636365684736') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.000725s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000691s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000437s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000647s ]
SELECT id as mod_config_id,`title`,`sub_title`,`image`,`assistant_image`,`type`,`foreign_key`,`url`,`col`,`bg_color`,`more_url` FROM `sj_shop_mod_config` WHERE ( `shop_id` = 170613328031256576 AND `mod_id` = 98 AND `status` = 1 ) AND `sj_shop_mod_config`.`del_time` = 0 ORDER BY `sort` [ RunTime:0.000407s ]
SELECT * FROM `sj_shop_mod_config` WHERE ( `id` = 354 ) AND `sj_shop_mod_config`.`del_time` = 0 LIMIT 1 [ RunTime:0.000468s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213058183277580288','213058183554404352','213058183822839808','213058184103858176','213058184376487936','213058184888193024','213058185194377216','213058185500561408','213058185743831040','213058190118490112','213058190642778112','213058191125123072','213058191565524992','213058192010121216','213058192425357312','213058192853176320','213058193314549760','213058193754951680','213058194308599808','213058194723835904','213058195160043520','213058195608834048','213058196263145472','213058196707741696','213058197135560704','213058197714374656','213058198272217088','213058198725201920','213058199140438016','213060698744295424','213060699247611904','250001091490484224','250001152966397952','250001164861444096','250001201238642688','250001207433629696','250001241130668032','250001254460166144','250001291978215424','250001404771438592','250001411293581312','250001417543094272','250001446437654528','250001473818071040','250001488510717952','250001497213898752','250001522547494912','250001529711366144') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) `_group_count_` [ RunTime:0.002857s ]
SELECT * FROM ( SELECT `P`.`id`,P.id as product_id,`name`,`sub_title`,PS.id as sku_id,`PS`.`market_price`,`PS`.`sales_price`,`P`.`thumb_img`,`product_score`,`cat_id`,`supplier_id`,`weight`,`P`.`add_time`,`sale_num` FROM `sj_product` `P` INNER JOIN `sj_product_sku` `PS` ON `P`.`id`=`PS`.`product_id` WHERE ( `P`.`id` IN ('213058183277580288','213058183554404352','213058183822839808','213058184103858176','213058184376487936','213058184888193024','213058185194377216','213058185500561408','213058185743831040','213058190118490112','213058190642778112','213058191125123072','213058191565524992','213058192010121216','213058192425357312','213058192853176320','213058193314549760','213058193754951680','213058194308599808','213058194723835904','213058195160043520','213058195608834048','213058196263145472','213058196707741696','213058197135560704','213058197714374656','213058198272217088','213058198725201920','213058199140438016','213060698744295424','213060699247611904','250001091490484224','250001152966397952','250001164861444096','250001201238642688','250001207433629696','250001241130668032','250001254460166144','250001291978215424','250001404771438592','250001411293581312','250001417543094272','250001446437654528','250001473818071040','250001488510717952','250001497213898752','250001522547494912','250001529711366144') AND `shop_id` = 170613328031256576 AND `P`.`status` = 1 AND `sell_status` = 1 AND `PS`.`status` = 1 AND `PS`.`del_time` = 0 ) AND `P`.`del_time` = 0 GROUP BY `P`.`id` ) a ORDER BY `product_score` DESC,`weight` ASC,`id` ASC LIMIT 0,15 [ RunTime:0.002420s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000686s ]
SELECT * FROM `sj_full_reduction` WHERE `sj_full_reduction`.`del_time` = 0 [ RunTime:0.000341s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250001201238642688' [ RunTime:0.000555s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250001206649294848' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000323s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250001206649294848' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000357s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250001091490484224' [ RunTime:0.000368s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250001098226536448' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000320s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250001098226536448' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000605s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250001488510717952' [ RunTime:0.000360s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250001493812318208' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000414s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250001493812318208' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000459s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058190642778112' [ RunTime:0.000414s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058191058014208' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000531s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058191058014208' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000628s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058198272217088' [ RunTime:0.000502s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058198670675968' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000357s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058198670675968' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000585s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058193314549760' [ RunTime:0.000387s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058193700425728' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000402s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058193700425728' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000492s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058195160043520' [ RunTime:0.000554s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058195533336576' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000511s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058195533336576' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000407s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250001446437654528' [ RunTime:0.000387s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250001451542122496' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000508s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250001451542122496' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000398s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058192425357312' [ RunTime:0.000340s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058192777678848' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000389s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058192777678848' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000314s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250001207433629696' [ RunTime:0.000456s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250001212873641984' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000338s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250001212873641984' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000480s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058190118490112' [ RunTime:0.000367s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058190567280640' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000536s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058190567280640' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000462s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058183277580288' [ RunTime:0.000424s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058183512461312' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000474s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058183512461312' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000695s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '250001411293581312' [ RunTime:0.000396s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '250001416737787904' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000462s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '250001416737787904' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000787s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058194723835904' [ RunTime:0.000519s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058195109711872' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000425s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058195109711872' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000565s ]
SELECT `quantity` FROM `sj_customer_purchase_limitation` WHERE `customer_id` = 0 AND `product_id` = '213058183554404352' [ RunTime:0.000622s ]
SELECT * FROM `sj_product_attr` WHERE ( `sku_id` = '213058183780896768' ) AND `sj_product_attr`.`del_time` = 0 [ RunTime:0.000473s ]
SELECT * FROM `sj_time_product` WHERE ( `sku_id` = '213058183780896768' AND `end_time` > 1728374187 AND `start_time` <= 1728374187 ) AND `sj_time_product`.`del_time` = 0 ORDER BY `start_time` ASC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000544s ]
SELECT * FROM `sj_time_product` WHERE ( `shop_id` = 170613328031256576 AND `start_time` >= 1728374187 ) AND `sj_time_product`.`del_time` = 0 GROUP BY `start_time` LIMIT 1 [ RunTime:0.000392s ]
SELECT * FROM `sj_time_product` WHERE ( `shop_id` = 170613328031256576 AND `start_time` <= 1728374187 AND `end_time` >= 1728374187 ) AND `sj_time_product`.`del_time` = 0 GROUP BY `start_time` LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`supplier_name` FROM `sj_supplier` WHERE `sj_supplier`.`del_time` = 0 [ RunTime:0.000510s ]
SHOW FULL COLUMNS FROM `sj_order` [ RunTime:0.001606s ]
SHOW FULL COLUMNS FROM `sj_order_info` [ RunTime:0.001046s ]
SHOW FULL COLUMNS FROM `sj_order_invoice` [ RunTime:0.000981s ]
SELECT * FROM `sj_customer` WHERE ( `id` = 0 ) AND `sj_customer`.`del_time` = 0 LIMIT 1 [ RunTime:0.000479s ]
SELECT COUNT(*) AS think_count FROM `sj_order` WHERE ( `customer_id` = 0 AND `status` = 0 AND `split` = 0 ) AND `sj_order`.`del_time` = 0 [ RunTime:0.000667s ]
SELECT * FROM `sj_customer` WHERE ( `id` = 0 ) AND `sj_customer`.`del_time` = 0 LIMIT 1 [ RunTime:0.000463s ]
SELECT COUNT(*) AS think_count FROM `sj_order` WHERE ( `customer_id` = 0 AND `status` = 1 AND `split` = 0 ) AND `sj_order`.`del_time` = 0 [ RunTime:0.000524s ]
SELECT * FROM `sj_customer` WHERE ( `id` = 0 ) AND `sj_customer`.`del_time` = 0 LIMIT 1 [ RunTime:0.000678s ]
SELECT COUNT(*) AS think_count FROM `sj_order` WHERE ( `customer_id` = 0 AND `status` = 2 AND `split` = 0 ) AND `sj_order`.`del_time` = 0 [ RunTime:0.000557s ]
SELECT * FROM `sj_customer` WHERE ( `id` = 0 ) AND `sj_customer`.`del_time` = 0 LIMIT 1 [ RunTime:0.000471s ]
SELECT COUNT(*) AS think_count FROM `sj_order` WHERE ( `customer_id` = 0 AND `status` = 3 AND `split` = 0 ) AND `sj_order`.`del_time` = 0 [ RunTime:0.000517s ]
SELECT * FROM `sj_article` WHERE `shop_id` = 170613328031256576 AND `type` = 2 ORDER BY `add_time` DESC,`sort` DESC LIMIT 4 [ RunTime:0.000473s ]
SELECT * FROM `sj_article` WHERE `shop_id` = 170613328031256576 AND `type` = 3 ORDER BY `add_time` DESC,`sort` DESC LIMIT 4 [ RunTime:0.000456s ]
SELECT * FROM `sj_article` WHERE `shop_id` = 170613328031256576 AND `type` = 4 ORDER BY `add_time` DESC,`sort` DESC LIMIT 4 [ RunTime:0.000558s ]