[ SQL ] SHOW COLUMNS FROM `cmf_portal_product` [ RunTime:0.000000s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_portal_product` `p` LEFT JOIN `cmf_portal_brand_product` `b` ON `p`.`product_no`=`b`.`product_no` LEFT JOIN `cmf_portal_product_img` `pi` ON `pi`.`product_no`=p.product_no and pi.img_type = 1 AND pi.img_order = 1 LEFT JOIN `cmf_portal_brand` `pb` ON `pb`.`brand_no`=`b`.`brand_no` LEFT JOIN `cmf_portal_category_product` `c` ON `p`.`product_no`=`c`.`product_no` LEFT JOIN `cmf_portal_category` `cp` ON `c`.`category_no`=`cp`.`category_no` WHERE `cp`.`id` IN ('86','87','88','89','90','91','92','93','94','95','96','97','98','99','100','101','102','448') AND `p`.`delete_time` = '0' [ RunTime:0.064456s ]
[ SQL ] SELECT distinct(p.id) ppid,p.id as pid,p.*,pb.logo band_logo,pi.img_name FROM `cmf_portal_product` `p` LEFT JOIN `cmf_portal_brand_product` `b` ON `p`.`product_no`=`b`.`product_no` LEFT JOIN `cmf_portal_product_img` `pi` ON `pi`.`product_no`=p.product_no and pi.img_type = 1 AND pi.img_order = 1 LEFT JOIN `cmf_portal_brand` `pb` ON `pb`.`brand_no`=`b`.`brand_no` LEFT JOIN `cmf_portal_category_product` `c` ON `p`.`product_no`=`c`.`product_no` LEFT JOIN `cmf_portal_category` `cp` ON `c`.`category_no`=`cp`.`category_no` WHERE `cp`.`id` IN ('86','87','88','89','90','91','92','93','94','95','96','97','98','99','100','101','102','448') AND `p`.`delete_time` = '0' AND `p`.`delete_time` = '0' AND `p`.`status` = '1' LIMIT 1584,24 [ RunTime:0.079106s ]
/119693a1.jpg "不锈钢酱汁炉(陶瓷内桶)")
/119694a1.jpg "不锈钢酱汁炉(陶瓷内桶)")
/119695a1.jpg "不锈钢钢盖汤炉(不锈钢内桶)")
/119696a1.jpg "不锈钢玻璃盖汤炉(不锈钢内桶)")
/119697a1.jpg "不锈钢钢盖汤炉(陶瓷内桶)")
/119698a1.jpg "不锈钢玻璃盖汤炉(陶瓷内桶)")
/120301a1.jpg "不锈钢钢盖汤炉(不锈钢内桶)")
/120302a1.jpg "不锈钢玻璃盖汤炉(不锈钢内桶)")
/120303a1.jpg "不锈钢钢盖汤炉(陶瓷内桶)")
/120304a1.jpg "不锈钢玻璃盖汤炉(陶瓷内桶)")
/120305a1.jpg "不锈钢钢盖汤炉(不锈钢内桶)")
/120306a1.jpg "不锈钢玻璃盖汤炉(不锈钢内桶)")
/120307a1.jpg "不锈钢钢盖汤炉(陶瓷内桶)")
/120308a1.jpg "不锈钢玻璃盖汤炉(陶瓷内桶)")
/120455a1.jpg "不锈钢钢盖汤炉(不锈钢内桶)")
中
EN
版权所有@ 东方厨具
粤公网安备44070302440850号
