商品详情--工程设备融资服务平台--工程设备融资服务平台-

主体
塔身配置	1 + 0
标高（M）	60
油缸	四油缸
钢丝绳	350M
电缆	120M
起重机构	-6

基本文件流程错误 SQL 调试

/home/wwwroot/kst.tpsns.com/index.php ( 3.33 KB )
/home/wwwroot/kst.tpsns.com/saas.php ( 5.34 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/start.php ( 0.72 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/base.php ( 2.60 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/Loader.php ( 20.23 KB )
/home/wwwroot/kst.tpsns.com/vendor/composer/autoload_namespaces.php ( 0.29 KB )
/home/wwwroot/kst.tpsns.com/vendor/composer/autoload_psr4.php ( 0.89 KB )
/home/wwwroot/kst.tpsns.com/vendor/composer/autoload_classmap.php ( 44.14 KB )
/home/wwwroot/kst.tpsns.com/vendor/composer/autoload_files.php ( 0.43 KB )
/home/wwwroot/kst.tpsns.com/vendor/symfony/polyfill-mbstring/bootstrap.php ( 3.96 KB )
/home/wwwroot/kst.tpsns.com/vendor/topthink/think-captcha/src/helper.php ( 1.59 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/Route.php ( 58.86 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/Config.php ( 6.38 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/Validate.php ( 40.54 KB )
/home/wwwroot/kst.tpsns.com/vendor/topthink/think-testing/src/config.php ( 0.65 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/Console.php ( 22.65 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/Error.php ( 3.79 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/convention.php ( 10.10 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/App.php ( 22.16 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/Request.php ( 48.59 KB )
/home/wwwroot/kst.tpsns.com/application/config.php ( 17.79 KB )
/home/wwwroot/kst.tpsns.com/application/database.php ( 2.12 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/Hook.php ( 4.71 KB )
/home/wwwroot/kst.tpsns.com/application/tags.php ( 0.09 KB )
/home/wwwroot/kst.tpsns.com/application/common.php ( 102.16 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/Env.php ( 1.21 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/helper.php ( 22.04 KB )
/home/wwwroot/kst.tpsns.com/application/function.php ( 42.78 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/Lang.php ( 7.23 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/Log.php ( 6.04 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/lang/zh-cn.php ( 11.58 KB )
/home/wwwroot/kst.tpsns.com/application/mobile/config.php ( 0.47 KB )
/home/wwwroot/kst.tpsns.com/application/mobile/html.php ( 0.96 KB )
/home/wwwroot/kst.tpsns.com/application/mobile/controller/Goods.php ( 30.47 KB )
/home/wwwroot/kst.tpsns.com/application/mobile/controller/MobileBase.php ( 19.60 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/Controller.php ( 8.07 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/traits/controller/Jump.php ( 4.90 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/View.php ( 6.77 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/view/driver/Think.php ( 5.64 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/Template.php ( 45.34 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/template/driver/File.php ( 2.17 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/Cache.php ( 6.10 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/cache/driver/File.php ( 7.31 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/cache/Driver.php ( 5.98 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/Session.php ( 10.86 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/Cookie.php ( 7.54 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/Db.php ( 6.67 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/db/connector/Mysql.php ( 3.89 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/db/Connection.php ( 30.08 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/db/Query.php ( 90.32 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/db/builder/Mysql.php ( 4.22 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/db/Builder.php ( 30.65 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/Url.php ( 12.71 KB )
/home/wwwroot/kst.tpsns.com/application/common/logic/GoodsLogic.php ( 67.77 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/Model.php ( 68.14 KB )
/home/wwwroot/kst.tpsns.com/application/common/model/Goods.php ( 9.33 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/Debug.php ( 7.13 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/exception/ErrorException.php ( 1.83 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/Exception.php ( 1.60 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/exception/Handle.php ( 8.72 KB )
/home/wwwroot/kst.tpsns.com/application/common/model/PromOrder.php ( 2.16 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/model/relation/HasMany.php ( 9.53 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/model/Relation.php ( 3.60 KB )
/home/wwwroot/kst.tpsns.com/application/common/model/GoodsAttr.php ( 0.83 KB )
/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php ( 101.46 KB )
/home/wwwroot/kst.tpsns.com/application/common/model/GoodsImages.php ( 0.73 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/model/relation/HasOne.php ( 6.72 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/model/relation/OneToOne.php ( 9.68 KB )
/home/wwwroot/kst.tpsns.com/application/common/model/Store.php ( 11.01 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/Response.php ( 8.33 KB )
/home/wwwroot/kst.tpsns.com/thinkphp/library/think/debug/Html.php ( 4.16 KB )

[8]未定义数组下标: 26[/home/wwwroot/kst.tpsns.com/application/common/logic/GoodsLogic.php:191]
[8]Use of undefined constant image_url - assumed 'image_url'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:106]
[8]未定义变量: address[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:303]
[8]未定义变量: province[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:304]
[8]未定义变量: province[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:304]
[8]未定义变量: province[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:304]
[8]未定义变量: address[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:306]
[8]未定义变量: city[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:307]
[8]未定义变量: city[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:307]
[8]未定义变量: city[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:307]
[8]未定义变量: district[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:310]
[8]未定义变量: district[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:310]
[8]未定义变量: district[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:310]
[8]未定义变量: twon[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:313]
[8]未定义变量: twon[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:313]
[8]未定义变量: twon[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:313]
[8]Use of undefined constant store_id - assumed 'store_id'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:433]
[8]Use of undefined constant store_id - assumed 'store_id'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:438]
[8]Use of undefined constant store_id - assumed 'store_id'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:446]
[8]Use of undefined constant goods_id - assumed 'goods_id'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:498]
[8]Use of undefined constant goods_name - assumed 'goods_name'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:501]
[8]Use of undefined constant shop_price - assumed 'shop_price'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:503]
[8]Use of undefined constant goods_id - assumed 'goods_id'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:498]
[8]Use of undefined constant goods_name - assumed 'goods_name'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:501]
[8]Use of undefined constant shop_price - assumed 'shop_price'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:503]
[8]Use of undefined constant goods_id - assumed 'goods_id'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:498]
[8]Use of undefined constant goods_name - assumed 'goods_name'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:501]
[8]Use of undefined constant shop_price - assumed 'shop_price'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:503]
[8]Use of undefined constant goods_id - assumed 'goods_id'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:498]
[8]Use of undefined constant goods_name - assumed 'goods_name'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:501]
[8]Use of undefined constant shop_price - assumed 'shop_price'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:503]
[8]Use of undefined constant goods_id - assumed 'goods_id'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:498]
[8]Use of undefined constant goods_name - assumed 'goods_name'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:501]
[8]Use of undefined constant shop_price - assumed 'shop_price'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:503]
[8]Use of undefined constant goods_id - assumed 'goods_id'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:498]
[8]Use of undefined constant goods_name - assumed 'goods_name'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:501]
[8]Use of undefined constant shop_price - assumed 'shop_price'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:503]
[8]Use of undefined constant attr_id - assumed 'attr_id'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:668]
[8]Use of undefined constant attr_value - assumed 'attr_value'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:669]
[8]Use of undefined constant attr_id - assumed 'attr_id'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:668]
[8]Use of undefined constant attr_value - assumed 'attr_value'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:669]
[8]Use of undefined constant attr_id - assumed 'attr_id'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:668]
[8]Use of undefined constant attr_value - assumed 'attr_value'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:669]
[8]Use of undefined constant attr_id - assumed 'attr_id'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:668]
[8]Use of undefined constant attr_value - assumed 'attr_value'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:669]
[8]Use of undefined constant attr_id - assumed 'attr_id'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:668]
[8]Use of undefined constant attr_value - assumed 'attr_value'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:669]
[8]Use of undefined constant attr_id - assumed 'attr_id'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:668]
[8]Use of undefined constant attr_value - assumed 'attr_value'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:669]
[8]Use of undefined constant store_id - assumed 'store_id'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:686]
[8]Use of undefined constant item_id - assumed 'item_id'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:845]
[8]Use of undefined constant item - assumed 'item'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:845]
[8]Use of undefined constant item_id - assumed 'item_id'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:847]
[8]Use of undefined constant item_id - assumed 'item_id'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:847]
[8]Use of undefined constant item - assumed 'item'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:847]
[8]Use of undefined constant goods_id - assumed 'goods_id'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:2011]
[8]Use of undefined constant goods_id - assumed 'goods_id'[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:2012]
[8]未定义变量: wechat_config[/home/wwwroot/kst.tpsns.com/runtime/temp/92e73ade85bd6f13604d523556995a0f.php:2158]

[ DB ] CONNECT:[ UseTime:0.000289s ] mysql:host=127.0.0.1;port=3306;dbname=bb2_tadiao;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tp_goods` [ RunTime:0.000842s ]
[ SQL ] SELECT * FROM `tp_goods` WHERE `goods_id` = 19 LIMIT 1 [ RunTime:0.000579s ]
[ SQL ] UPDATE `tp_goods` SET `click_count`=2029 WHERE `goods_id` = 19 [ RunTime:0.001531s ]
[ SQL ] SHOW COLUMNS FROM `tp_goods_attribute` [ RunTime:0.000427s ]
[ SQL ] SELECT `attr_id`,`attr_name` FROM `tp_goods_attribute` [ RunTime:0.000229s ]
[ SQL ] SHOW COLUMNS FROM `tp_spec_goods_price` [ RunTime:0.000423s ]
[ SQL ] SELECT `key`,`price`,`store_count`,`item_id`,`prom_id` FROM `tp_spec_goods_price` WHERE `goods_id` = 19 [ RunTime:0.000247s ]
[ SQL ] SELECT GROUP_CONCAT(`key` ORDER BY store_count desc SEPARATOR '_') FROM `tp_spec_goods_price` WHERE `goods_id` = 19 LIMIT 1 [ RunTime:0.000236s ]
[ SQL ] SHOW COLUMNS FROM `tp_spec_image` [ RunTime:0.000387s ]
[ SQL ] SELECT `spec_image_id`,`src` FROM `tp_spec_image` WHERE `goods_id` = 19 AND ( src != '' ) [ RunTime:0.000214s ]
[ SQL ] SELECT a.name,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(26) ORDER BY a.order DESC,b.id [ RunTime:0.000218s ]
[ SQL ] SHOW COLUMNS FROM `tp_goods_collect` [ RunTime:0.000379s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tp_goods_collect` WHERE `goods_id` = 19 AND `user_id` IS NULL LIMIT 1 [ RunTime:0.000165s ]
[ SQL ] SHOW COLUMNS FROM `tp_coupon` [ RunTime:0.000460s ]
[ SQL ] SELECT `c`.`id`,`c`.*,`gc`.`goods_id`,`gc`.`goods_category_id` FROM `tp_coupon` `c` LEFT JOIN `tp_goods_coupon` `gc` ON `gc`.`coupon_id`=`c`.`id` WHERE `type` = 2 AND `status` = 1 AND `send_start_time` <= 1763044691 AND `send_end_time` >= 1763044691 AND `c`.`store_id` IN ('-1',0) AND ( createnum>send_num or createnum=0 ) [ RunTime:0.000341s ]
[ SQL ] SHOW COLUMNS FROM `tp_prom_goods` [ RunTime:0.000428s ]
[ SQL ] SELECT * FROM `tp_prom_goods` WHERE `status` = 1 AND `start_time` <= 1763044691 AND `end_time` >= 1763044691 AND `store_id` = 0 AND `id` = 0 LIMIT 1 [ RunTime:0.000409s ]
[ SQL ] SHOW COLUMNS FROM `tp_prom_order` [ RunTime:0.000406s ]
[ SQL ] SELECT * FROM `tp_prom_order` WHERE `status` = 1 AND `start_time` <= 1763044691 AND `end_time` >= 1763044691 AND `store_id` = 0 ORDER BY `orderby` [ RunTime:0.000237s ]
[ SQL ] SELECT * FROM `tp_prom_order` WHERE `start_time` <= 1763044691 AND `end_time` > 1763044691 AND `status` = 1 AND `store_id` = 0 ORDER BY id desc LIMIT 3 [ RunTime:0.000246s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tp_goods` WHERE `store_id` = 0 AND `is_on_sale` = 1 LIMIT 1 [ RunTime:0.000216s ]
[ SQL ] SHOW COLUMNS FROM `tp_goods_attr` [ RunTime:0.000374s ]
[ SQL ] SELECT * FROM `tp_goods_attr` LEFT JOIN `tp_goods_attribute` ON `tp_goods_attribute`.`attr_id`=`tp_goods_attr`.`attr_id` WHERE `tp_goods_attribute`.`attr_index` = 1 AND `tp_goods_attr`.`goods_id` = 19 ORDER BY tp_goods_attribute.order DESC [ RunTime:0.000429s ]
[ SQL ] SHOW COLUMNS FROM `tp_goods_images` [ RunTime:0.000404s ]
[ SQL ] SELECT * FROM `tp_goods_images` WHERE `goods_id` = 19 ORDER BY img_sort asc [ RunTime:0.000287s ]
[ SQL ] SHOW COLUMNS FROM `tp_store` [ RunTime:0.000705s ]
[ SQL ] SELECT * FROM `tp_store` WHERE `store_id` = 0 LIMIT 1 [ RunTime:0.000393s ]
[ SQL ] SHOW COLUMNS FROM `tp_comment` [ RunTime:0.000487s ]
[ 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` = 19 AND `deleted` = 0 AND `parent_id` = 0 GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000302s ]
[ 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` = 19 AND `deleted` = 0 AND `parent_id` = 0 GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000293s ]
[ 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` = 19 AND `deleted` = 0 AND `parent_id` = 0 GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000261s ]
[ 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` = 19 AND `deleted` = 0 AND `parent_id` = 0 GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000291s ]
[ 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` = 19 AND `deleted` = 0 AND `parent_id` = 0 GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000342s ]
[ 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` = 19 AND `deleted` = 0 AND `parent_id` = 0 GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000298s ]
[ 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` = 19 AND `deleted` = 0 AND `parent_id` = 0 GROUP BY `goods_id` LIMIT 1 [ RunTime:0.000261s ]

为您推荐

PT7015塔式起重机