[8]Use of undefined constant sure_to_submit - assumed 'sure_to_submit'[/www/wwwroot/joyb2bprod/runtime/temp/f46ce3be25ec4ecf8eb19e2cf57c6b3f.php:4401]
[8]Use of undefined constant download - assumed 'download'[/www/wwwroot/joyb2bprod/runtime/temp/f46ce3be25ec4ecf8eb19e2cf57c6b3f.php:4401]
[8]Use of undefined constant confirm - assumed 'confirm'[/www/wwwroot/joyb2bprod/runtime/temp/f46ce3be25ec4ecf8eb19e2cf57c6b3f.php:4401]
[8]Use of undefined constant cancel - assumed 'cancel'[/www/wwwroot/joyb2bprod/runtime/temp/f46ce3be25ec4ecf8eb19e2cf57c6b3f.php:4401]
[8]Use of undefined constant confirm - assumed 'confirm'[/www/wwwroot/joyb2bprod/runtime/temp/f46ce3be25ec4ecf8eb19e2cf57c6b3f.php:4473]
[8]Use of undefined constant cancel - assumed 'cancel'[/www/wwwroot/joyb2bprod/runtime/temp/f46ce3be25ec4ecf8eb19e2cf57c6b3f.php:4473]
[ DB ] CONNECT:[ UseTime:0.000446s ] mysql:host=127.0.0.1;port=3306;dbname=bb2_yunhui_online2;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `tp_goods_category` [ RunTime:0.000757s ]
[ SQL ] SELECT * FROM `tp_goods_category` WHERE `is_show` = 1 ORDER BY sort_order desc [ RunTime:0.005420s ]
[ SQL ] SHOW COLUMNS FROM `tp_seller` [ RunTime:0.001011s ]
[ SQL ] SELECT * FROM `tp_seller` WHERE `user_id` IS NULL LIMIT 1 [ RunTime:0.000391s ]
[ SQL ] SHOW COLUMNS FROM `tp_business_manager` [ RunTime:0.000433s ]
[ SQL ] SELECT * FROM `tp_business_manager` WHERE `manager_id` IS NULL LIMIT 1 [ RunTime:0.000259s ]
[ SQL ] SHOW COLUMNS FROM `tp_currency` [ RunTime:0.000476s ]
[ SQL ] SELECT * FROM `tp_currency` WHERE `lang_code` = 'zh' LIMIT 1 [ RunTime:0.000282s ]
[ SQL ] SELECT * FROM `tp_currency` WHERE `is_show` = 1 [ RunTime:0.000226s ]
[ SQL ] SHOW COLUMNS FROM `tp_goods` [ RunTime:0.000713s ]
[ SQL ] SELECT * FROM `tp_goods` WHERE `goods_id` = 200 LIMIT 1 [ RunTime:0.000580s ]
[ SQL ] UPDATE `tp_goods` SET `click_count`=1 WHERE `goods_id` = 200 [ RunTime:0.004857s ]
[ SQL ] SHOW COLUMNS FROM `tp_goods_attr` [ RunTime:0.000476s ]
[ SQL ] SELECT `b`.`attr_id`,`b`.`attr_name`,`a`.`attr_value`,`a`.`attr_value_zh`,`b`.`attr_name_zh` FROM `tp_goods_attr` `a` LEFT JOIN `tp_goods_attribute` `b` ON `a`.`attr_id`=`b`.`attr_id` WHERE `a`.`goods_id` = 200 AND `b`.`attr_index` = 1 ORDER BY b.order DESC [ RunTime:0.000516s ]
[ SQL ] SHOW COLUMNS FROM `tp_spec_goods_price` [ RunTime:0.000499s ]
[ SQL ] SELECT * FROM `tp_spec_goods_price` WHERE `goods_id` = 200 [ RunTime:0.000363s ]
[ SQL ] SHOW COLUMNS FROM `tp_store_warehouse` [ RunTime:0.000457s ]
[ SQL ] SELECT * FROM `tp_store_warehouse` WHERE `id` = 81 LIMIT 1 [ RunTime:0.000295s ]
[ SQL ] SELECT `warehouse_id` FROM `tp_spec_goods_price` WHERE `goods_id` = 200 [ RunTime:0.000293s ]
[ SQL ] SHOW COLUMNS FROM `tp_store_warehouse_related` [ RunTime:0.000414s ]
[ SQL ] SELECT `related_id` FROM `tp_store_warehouse_related` WHERE `warehouse_id` IN (81) [ RunTime:0.000241s ]
[ SQL ] SHOW COLUMNS FROM `tp_ec_platform_address` [ RunTime:0.000495s ]
[ SQL ] SELECT `p`.`platform_id`,`p`.`name`,`p`.`logo`,GROUP_CONCAT(a.name) as addresses FROM `tp_ec_platform_address` `a` INNER JOIN `tp_ec_platform` `p` ON `a`.`platform_id`=`p`.`platform_id` WHERE `a`.`id` IN ('143','2','3') GROUP BY `a`.`platform_id` [ RunTime:0.000471s ]
[ SQL ] SHOW COLUMNS FROM `tp_freight_config` [ RunTime:0.000362s ]
[ SQL ] SELECT `shipping_id` FROM `tp_freight_config` WHERE `store_id` = 122 AND `template_id` = 0 GROUP BY `shipping_id` [ RunTime:0.000241s ]
[ SQL ] SHOW COLUMNS FROM `tp_shipping` [ RunTime:0.000397s ]
[ SQL ] SELECT * FROM `tp_shipping` WHERE `shipping_id` IN ('') [ RunTime:0.000208s ]
[ SQL ] SELECT GROUP_CONCAT(`key` ORDER BY store_count desc SEPARATOR '_') FROM `tp_spec_goods_price` WHERE `goods_id` = 200 LIMIT 1 [ RunTime:0.000335s ]
[ SQL ] SHOW COLUMNS FROM `tp_spec_image` [ RunTime:0.000393s ]
[ SQL ] SELECT `spec_image_id`,`src` FROM `tp_spec_image` WHERE `goods_id` = 200 AND ( src != '' ) [ RunTime:0.000271s ]
[ SQL ] SELECT a.name,a.name_zh,a.name_en,a.name_ru, b.item,b.item_zh,b.item_en,b.item_ru, a.order,b.* FROM tp_spec AS a INNER JOIN tp_spec_item AS b ON a.id = b.spec_id WHERE b.id IN(2901,2957) ORDER BY a.order DESC,b.id [ RunTime:0.000344s ]
[ SQL ] SELECT `goods_name`,`goods_id`,`shop_price`,`sales_sum`,`goods_name_zh`,`goods_content_zh` FROM `tp_goods` WHERE `cat_id1` <> 5025 AND `is_on_sale` = 1 LIMIT 12 [ RunTime:0.004185s ]
[ SQL ] SHOW COLUMNS FROM `tp_guarantee` [ RunTime:0.000488s ]
[ SQL ] SELECT `grt_id` FROM `tp_guarantee` WHERE `store_id` = 122 AND `isopen` = 1 AND `auditstate` = 4 [ RunTime:0.000222s ]
[ SQL ] SHOW COLUMNS FROM `tp_guarantee_item` [ RunTime:0.000406s ]
[ SQL ] SELECT * FROM `tp_guarantee_item` WHERE `grt_id` IN ('') [ RunTime:0.000207s ]
[ SQL ] SHOW COLUMNS FROM `tp_menu_goods_field` [ RunTime:0.000320s ]
[ SQL ] SELECT * FROM `tp_menu_goods_field` [ RunTime:0.000237s ]
[ SQL ] SHOW COLUMNS FROM `tp_config` [ RunTime:0.000343s ]
[ SQL ] SELECT * FROM `tp_config` WHERE `inc_type` = 'basic' [ RunTime:0.000344s ]
[ SQL ] SELECT * FROM `tp_config` WHERE `inc_type` = 'shopping' [ RunTime:0.000378s ]
[ SQL ] SHOW COLUMNS FROM `tp_ad` [ RunTime:0.000855s ]
[ SQL ] SELECT * FROM `tp_ad` WHERE ( pid=1 and enabled = 1 and start_time <= 1747243604 and end_time >= 1747243604 ) ORDER BY orderby desc LIMIT 1 [ RunTime:0.000469s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 6144 limit 2 [ RunTime:0.000530s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 9987 limit 2 [ RunTime:0.000583s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 37893 limit 2 [ RunTime:0.000631s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 35338 limit 2 [ RunTime:0.000495s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 15901 limit 2 [ RunTime:0.000436s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 1315 limit 2 [ RunTime:0.000594s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 1316 limit 2 [ RunTime:0.000496s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 1318 limit 2 [ RunTime:0.000819s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 1319 limit 2 [ RunTime:0.000645s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 6196 limit 2 [ RunTime:0.000739s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 43575 limit 2 [ RunTime:0.000637s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 6728 limit 2 [ RunTime:0.000813s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 6994 limit 2 [ RunTime:0.000652s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 1620 limit 2 [ RunTime:0.000531s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 37462 limit 2 [ RunTime:0.000764s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 6233 limit 2 [ RunTime:0.000668s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 16750 limit 2 [ RunTime:0.000562s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 34675 limit 2 [ RunTime:0.000563s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 27508 limit 2 [ RunTime:0.000553s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 9847 limit 2 [ RunTime:0.000479s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 9855 limit 2 [ RunTime:0.000483s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 652 limit 2 [ RunTime:0.000544s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 670 limit 2 [ RunTime:0.000560s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 5025 limit 2 [ RunTime:0.000483s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 1713 limit 2 [ RunTime:0.000565s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 17329 limit 2 [ RunTime:0.000469s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 34767 limit 2 [ RunTime:0.000558s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 11729 limit 2 [ RunTime:0.000537s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 35025 limit 2 [ RunTime:0.000536s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 36320 limit 2 [ RunTime:0.000724s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 737 limit 2 [ RunTime:0.000866s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 9192 limit 2 [ RunTime:0.000785s ]
[ SQL ] select * from tp_goods g inner join tp_flash_sale as f on g.goods_id = f.goods_id where start_time < 1747243604 and end_time > 1747243604 and status = 1 and cat_id1 = 14065 limit 2 [ RunTime:0.000675s ]
[ SQL ] SELECT * FROM `tp_goods_category` WHERE `id` = 5025 LIMIT 1 [ RunTime:0.000367s ]
[ SQL ] SELECT * FROM `tp_goods_category` WHERE `id` = 28638 LIMIT 1 [ RunTime:0.000307s ]
[ SQL ] SELECT * FROM `tp_goods_category` WHERE `id` = 28639 LIMIT 1 [ RunTime:0.000250s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 200 LIMIT 1 [ RunTime:0.000275s ]
[ SQL ] SELECT `name`,`value` FROM `tp_config` WHERE `name` IN ('oss_key_id','oss_key_secret','oss_endpoint','oss_bucket') [ RunTime:0.000497s ]
[ SQL ] SHOW COLUMNS FROM `tp_goods_images` [ RunTime:0.000654s ]
[ SQL ] SELECT * FROM `tp_goods_images` WHERE `goods_id` = 200 ORDER BY img_sort asc [ RunTime:0.000363s ]
[ SQL ] SHOW COLUMNS FROM `tp_comment` [ RunTime:0.000616s ]
[ SQL ] SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when goods_rank >= 4 and goods_rank <= 5 then 1 else 0 end) as high_sum,sum(case when goods_rank >= 3 and goods_rank <4 then 1 else 0 end) as center_sum,sum(case when goods_rank < 3 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 200 AND `deleted` = 0 AND `parent_id` = 0 GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000498s ]
[ SQL ] SHOW COLUMNS FROM `tp_store` [ RunTime:0.001060s ]
[ SQL ] SELECT * FROM `tp_store` WHERE `store_id` = 122 LIMIT 1 [ RunTime:0.000702s ]
[ SQL ] SHOW COLUMNS FROM `tp_brand` [ RunTime:0.000812s ]
[ SQL ] SELECT * FROM `tp_brand` WHERE `id` = 155 LIMIT 1 [ RunTime:0.000433s ]
[ SQL ] SHOW COLUMNS FROM `tp_store_goods_class` [ RunTime:0.000606s ]
[ SQL ] SELECT * FROM `tp_store_goods_class` WHERE `store_id` = 122 AND `parent_id` = 0 [ RunTime:0.000355s ]
[ SQL ] select * from tp_brand where is_hot=1 and cat_name='' and status=0 ORDER BY sort [ RunTime:0.000581s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 84 LIMIT 1 [ RunTime:0.000310s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 176 LIMIT 1 [ RunTime:0.000289s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 277 LIMIT 1 [ RunTime:0.000232s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 282 LIMIT 1 [ RunTime:0.000285s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 518 LIMIT 1 [ RunTime:0.000328s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 1118 LIMIT 1 [ RunTime:0.000283s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 1390 LIMIT 1 [ RunTime:0.000288s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 1573 LIMIT 1 [ RunTime:0.000282s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 1574 LIMIT 1 [ RunTime:0.000285s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 1575 LIMIT 1 [ RunTime:0.000349s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 1576 LIMIT 1 [ RunTime:0.000388s ]
[ SQL ] SELECT `original_img` FROM `tp_goods` WHERE `goods_id` = 1577 LIMIT 1 [ RunTime:0.000347s ]
[ SQL ] SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when goods_rank >= 4 and goods_rank <= 5 then 1 else 0 end) as high_sum,sum(case when goods_rank >= 3 and goods_rank <4 then 1 else 0 end) as center_sum,sum(case when goods_rank < 3 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 200 AND `deleted` = 0 AND `parent_id` = 0 GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000564s ]
[ SQL ] SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when goods_rank >= 4 and goods_rank <= 5 then 1 else 0 end) as high_sum,sum(case when goods_rank >= 3 and goods_rank <4 then 1 else 0 end) as center_sum,sum(case when goods_rank < 3 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 200 AND `deleted` = 0 AND `parent_id` = 0 GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000376s ]
[ SQL ] SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when goods_rank >= 4 and goods_rank <= 5 then 1 else 0 end) as high_sum,sum(case when goods_rank >= 3 and goods_rank <4 then 1 else 0 end) as center_sum,sum(case when goods_rank < 3 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 200 AND `deleted` = 0 AND `parent_id` = 0 GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000374s ]
[ SQL ] SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when goods_rank >= 4 and goods_rank <= 5 then 1 else 0 end) as high_sum,sum(case when goods_rank >= 3 and goods_rank <4 then 1 else 0 end) as center_sum,sum(case when goods_rank < 3 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 200 AND `deleted` = 0 AND `parent_id` = 0 GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000355s ]
[ SQL ] SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when goods_rank >= 4 and goods_rank <= 5 then 1 else 0 end) as high_sum,sum(case when goods_rank >= 3 and goods_rank <4 then 1 else 0 end) as center_sum,sum(case when goods_rank < 3 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 200 AND `deleted` = 0 AND `parent_id` = 0 GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000335s ]
[ SQL ] SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when goods_rank >= 4 and goods_rank <= 5 then 1 else 0 end) as high_sum,sum(case when goods_rank >= 3 and goods_rank <4 then 1 else 0 end) as center_sum,sum(case when goods_rank < 3 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 200 AND `deleted` = 0 AND `parent_id` = 0 GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000362s ]
[ SQL ] SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when goods_rank >= 4 and goods_rank <= 5 then 1 else 0 end) as high_sum,sum(case when goods_rank >= 3 and goods_rank <4 then 1 else 0 end) as center_sum,sum(case when goods_rank < 3 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 200 AND `deleted` = 0 AND `parent_id` = 0 GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000306s ]
[ SQL ] SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when goods_rank >= 4 and goods_rank <= 5 then 1 else 0 end) as high_sum,sum(case when goods_rank >= 3 and goods_rank <4 then 1 else 0 end) as center_sum,sum(case when goods_rank < 3 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 200 AND `deleted` = 0 AND `parent_id` = 0 GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000265s ]
[ SQL ] SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when goods_rank >= 4 and goods_rank <= 5 then 1 else 0 end) as high_sum,sum(case when goods_rank >= 3 and goods_rank <4 then 1 else 0 end) as center_sum,sum(case when goods_rank < 3 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 200 AND `deleted` = 0 AND `parent_id` = 0 GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000305s ]
[ SQL ] SELECT count(comment_id) AS c,`impression` FROM `tp_comment` WHERE `deleted` = 0 AND `goods_id` = 200 GROUP BY `impression` [ RunTime:0.000261s ]
[ SQL ] SELECT count(comment_id) AS c,`impression` FROM `tp_comment` WHERE `deleted` = 0 AND `goods_id` = 200 GROUP BY `impression` [ RunTime:0.000257s ]
[ SQL ] SELECT count(comment_id) AS c,`impression` FROM `tp_comment` WHERE `deleted` = 0 AND `goods_id` = 200 GROUP BY `impression` [ RunTime:0.000255s ]
[ SQL ] SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when goods_rank >= 4 and goods_rank <= 5 then 1 else 0 end) as high_sum,sum(case when goods_rank >= 3 and goods_rank <4 then 1 else 0 end) as center_sum,sum(case when goods_rank < 3 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 200 AND `deleted` = 0 AND `parent_id` = 0 GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000278s ]
[ SQL ] SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when goods_rank >= 4 and goods_rank <= 5 then 1 else 0 end) as high_sum,sum(case when goods_rank >= 3 and goods_rank <4 then 1 else 0 end) as center_sum,sum(case when goods_rank < 3 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 200 AND `deleted` = 0 AND `parent_id` = 0 GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000287s ]
[ SQL ] SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when goods_rank >= 4 and goods_rank <= 5 then 1 else 0 end) as high_sum,sum(case when goods_rank >= 3 and goods_rank <4 then 1 else 0 end) as center_sum,sum(case when goods_rank < 3 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 200 AND `deleted` = 0 AND `parent_id` = 0 GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000304s ]
[ SQL ] SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when goods_rank >= 4 and goods_rank <= 5 then 1 else 0 end) as high_sum,sum(case when goods_rank >= 3 and goods_rank <4 then 1 else 0 end) as center_sum,sum(case when goods_rank < 3 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 200 AND `deleted` = 0 AND `parent_id` = 0 GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000347s ]
[ SQL ] SELECT sum(case when img !='' and img not like 'N;%' then 1 else 0 end) as img_sum,sum(case when goods_rank >= 4 and goods_rank <= 5 then 1 else 0 end) as high_sum,sum(case when goods_rank >= 3 and goods_rank <4 then 1 else 0 end) as center_sum,sum(case when goods_rank < 3 then 1 else 0 end) as low_sum,count(comment_id) as total_sum FROM `tp_comment` WHERE `is_show` = 1 AND `goods_id` = 200 AND `deleted` = 0 AND `parent_id` = 0 GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000324s ]
[ SQL ] select * from `tp_article` where cat_id = 3 and is_open=1 limit 5 [ RunTime:0.000366s ]
[ SQL ] select * from `tp_article` where cat_id = 11 and is_open=1 limit 5 [ RunTime:0.000287s ]
[ SQL ] select * from `tp_article` where cat_id = 13 and is_open=1 limit 5 [ RunTime:0.000304s ]
[ SQL ] select * from `tp_article` where cat_id = 15 and is_open=1 limit 5 [ RunTime:0.000288s ]
[ SQL ] select * from `tp_friend_link` where is_show=1 [ RunTime:0.000265s ]
[ SQL ] select * from `tp_friend_link` where is_show=1 [ RunTime:0.000233s ]
[ SQL ] SELECT * FROM `tp_navigation` where is_show = 1 AND position = 2 ORDER BY `sort` DESC [ RunTime:0.000331s ]