[ SQL ] SHOW COLUMNS FROM `cmf_goods_sku` [ RunTime:0.000373s ]
[ SQL ] SHOW COLUMNS FROM `cmf_goods` [ RunTime:0.000403s ]
[ SQL ] SELECT *,(sales_initial + sales_actual) as goods_sales,( SELECT MIN(goods_price) FROM `cmf_goods_sku` WHERE `cmf_goods_sku`.`wxapp_id` = 10001 AND ( `goods_id` = `cmf_goods`.`goods_id` ) ) AS goods_min_price,( SELECT MAX(goods_price) FROM `cmf_goods_sku` WHERE `cmf_goods_sku`.`wxapp_id` = 10001 AND ( `goods_id` = `cmf_goods`.`goods_id` ) ) AS goods_max_price FROM `cmf_goods` WHERE `cmf_goods`.`wxapp_id` = 10001 AND `is_delete` = 0 AND `goods_status` = 10 AND `is_tuijian` = 1 ORDER BY `goods_sort`,`goods_id` DESC LIMIT 8 [ RunTime:0.000258s ]
[ SQL ] SHOW COLUMNS FROM `cmf_goods_image` [ RunTime:0.000319s ]
[ SQL ] SELECT * FROM `cmf_goods_image` WHERE `cmf_goods_image`.`wxapp_id` = 10001 AND `goods_id` IN (10065,10024,10022,10053,10039,10037,10042,10052) ORDER BY `id` ASC [ RunTime:0.000167s ]
[ SQL ] SHOW COLUMNS FROM `cmf_upload_file` [ RunTime:0.000332s ]
[ SQL ] SELECT * FROM `cmf_upload_file` WHERE `cmf_upload_file`.`wxapp_id` = 10001 AND `file_id` IN (10232,10171,10024,10127,10065,10054,10118,10090,10170) [ RunTime:0.000184s ]
[ SQL ] SELECT * FROM `cmf_goods_sku` WHERE `cmf_goods_sku`.`wxapp_id` = 10001 AND `goods_id` IN (10065,10024,10022,10053,10039,10037,10042,10052) ORDER BY `goods_sku_id` ASC [ RunTime:0.000179s ]
[ SQL ] SHOW COLUMNS FROM `cmf_banzu` [ RunTime:0.000369s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_banzu` `a` LEFT JOIN `cmf_user_type` `user_type` ON `user_type`.`id`=`a`.`type_id` LEFT JOIN `cmf_qiye` `qiye` ON `qiye`.`id`=`a`.`qiye_id` [ RunTime:0.000139s ]
[ SQL ] SELECT `a`.*,qiye.name as qiye_name,user_type.name as type_name FROM `cmf_banzu` `a` LEFT JOIN `cmf_user_type` `user_type` ON `user_type`.`id`=`a`.`type_id` LEFT JOIN `cmf_qiye` `qiye` ON `qiye`.`id`=`a`.`qiye_id` ORDER BY `create_time` DESC LIMIT 0,15 [ RunTime:0.000159s ]
[ SQL ] SHOW COLUMNS FROM `cmf_zhaobiao` [ RunTime:0.000368s ]
[ SQL ] SELECT `a`.*,qiye.name as qiye_name,user_type.name as type_name FROM `cmf_zhaobiao` `a` LEFT JOIN `cmf_user_type` `user_type` ON `user_type`.`id`=`a`.`type_id` LEFT JOIN `cmf_qiye` `qiye` ON `qiye`.`id`=`a`.`qiye_id` ORDER BY `create_time` DESC [ RunTime:0.000177s ]
[ SQL ] SHOW COLUMNS FROM `cmf_qiuzhi` [ RunTime:0.000417s ]
[ SQL ] SELECT `a`.*,user_type.name as type_name,`user`.`avatar` FROM `cmf_qiuzhi` `a` LEFT JOIN `cmf_user` `user` ON `user`.`id`=`a`.`user_id` LEFT JOIN `cmf_user_type` `user_type` ON `user_type`.`id`=`a`.`gangwei_type` ORDER BY `create_time` DESC [ RunTime:0.000172s ]
[ SQL ] SHOW COLUMNS FROM `cmf_zulin` [ RunTime:0.000366s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_zulin` `a` LEFT JOIN `cmf_user_type` `user_type` ON `user_type`.`id`=`a`.`type_id` LEFT JOIN `cmf_qiye` `qiye` ON `qiye`.`id`=`a`.`qiye_id` [ RunTime:0.000144s ]
[ SQL ] SELECT `a`.*,qiye.name as qiye_name,user_type.name as type_name FROM `cmf_zulin` `a` LEFT JOIN `cmf_user_type` `user_type` ON `user_type`.`id`=`a`.`type_id` LEFT JOIN `cmf_qiye` `qiye` ON `qiye`.`id`=`a`.`qiye_id` ORDER BY `create_time` DESC LIMIT 0,15 [ RunTime:0.000180s ]
在线咨询
