[ SQL ] SHOW COLUMNS FROM `cmf_goods_sku` [ RunTime:0.000393s ]
[ SQL ] SHOW COLUMNS FROM `cmf_goods` [ RunTime:0.000427s ]
[ 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.000280s ]
[ SQL ] SHOW COLUMNS FROM `cmf_goods_image` [ RunTime:0.000410s ]
[ 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.000195s ]
[ SQL ] SHOW COLUMNS FROM `cmf_upload_file` [ RunTime:0.000337s ]
[ 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.000172s ]
[ 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.000198s ]
[ SQL ] SHOW COLUMNS FROM `cmf_banzu` [ RunTime:0.000371s ]
[ 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.000140s ]
[ 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.000154s ]
[ SQL ] SHOW COLUMNS FROM `cmf_zhaobiao` [ RunTime:0.000369s ]
[ 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.000169s ]
[ SQL ] SHOW COLUMNS FROM `cmf_qiuzhi` [ RunTime:0.000397s ]
[ 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.000500s ]
[ SQL ] SHOW COLUMNS FROM `cmf_zulin` [ RunTime:0.000397s ]
[ 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.000147s ]
[ 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.000149s ]
在线咨询
