[ 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` WHERE `pb`.`id` = '2' AND `p`.`delete_time` = '0' [ RunTime:0.062500s ]
[ 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` WHERE `pb`.`id` = '2' AND `p`.`delete_time` = '0' AND `p`.`delete_time` = '0' AND `p`.`status` = '1' LIMIT 5328,24 [ RunTime:0.109375s ]
中
EN
胶柄手持磨刀器/190119a1.jpg "(普通型)胶柄手持磨刀器")
/121997a1.jpg "不锈钢圆形酱汁炉(不锈钢内胆)")
/121999a1.jpg "不锈钢圆形酱汁炉(陶瓷内胆)")
版权所有@2020 东方厨具
