[ SQL ] SHOW COLUMNS FROM `cmf_portal_product` [ RunTime:0.000977s ]
[ 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_series_product` `s` ON `p`.`product_no`=`s`.`product_no` LEFT JOIN `cmf_portal_series` `ps` ON `ps`.`series_no`=`s`.`series_no` WHERE `ps`.`id` = '10' AND `p`.`delete_time` = '0' [ RunTime:0.005860s ]
[ 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_series_product` `s` ON `p`.`product_no`=`s`.`product_no` LEFT JOIN `cmf_portal_series` `ps` ON `ps`.`series_no`=`s`.`series_no` WHERE `ps`.`id` = '10' AND `p`.`delete_time` = '0' AND `p`.`delete_time` = '0' AND `p`.`status` = '1' LIMIT 0,24 [ RunTime:0.000977s ]