[ 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_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 ('103','104','105','106','107','108','109','110','111','112','113','114','115','116','117','118','119','120','121','122','123','124','125','126','127') AND `p`.`delete_time` = '0' [ RunTime:0.046877s ]
[ SQL ] SELECT distinct(p.id) ppid, p.id as pid,p.*,pb.logo band_logo FROM `cmf_portal_product` `p` LEFT JOIN `cmf_portal_brand_product` `b` ON `p`.`product_no`=`b`.`product_no` 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 ('103','104','105','106','107','108','109','110','111','112','113','114','115','116','117','118','119','120','121','122','123','124','125','126','127') AND `p`.`delete_time` = '0' AND `p`.`delete_time` = '0' LIMIT 288,24 [ RunTime:0.047855s ]
珍珠奶茶吸管盒/191902a1.jpg "Pipette box of pearl bubble tea")
不锈钢筷子盒/192000a1.jpg "Stainless steel chopsticks box")
筷子盒/192004a1.jpg "Stainless steel (heightened) chopsticks box")
筷子盒/192002a1.jpg "Ultraviolet sterilization chopsticks box")
中
EN
Copyright @2021 EAST Kitchenware
