[ SQL ] SHOW COLUMNS FROM `cmf_portal_product` [ RunTime:0.000000s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `cmf_portal_product` `p` LEFT JOIN `cmf_portal_brand_product` `b` ON `p`.`product_no`=`b`.`product_no` LEFT JOIN `cmf_portal_series_product` `s` ON `p`.`product_no`=`s`.`product_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` LEFT JOIN `cmf_portal_series` `ps` ON `ps`.`series_no`=`s`.`series_no` LEFT JOIN `cmf_portal_brand` `pb` ON `pb`.`brand_no`=`b`.`brand_no` LEFT JOIN `cmf_portal_product_content` `pc` ON `pc`.`product_no`=`p`.`product_no` WHERE `cp`.`id` IN ('85','86','87','88','89','90','91','92','93','94','95','96','97','98','99','100','101','102','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','128','129','130','131','132','133','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','154','155','156') AND `p`.`delete_time` = '0' GROUP BY `p`.`id` ) `_group_count_` [ RunTime:0.396418s ]
[ SQL ] SELECT `p`.* FROM `cmf_portal_product` `p` LEFT JOIN `cmf_portal_brand_product` `b` ON `p`.`product_no`=`b`.`product_no` LEFT JOIN `cmf_portal_series_product` `s` ON `p`.`product_no`=`s`.`product_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` LEFT JOIN `cmf_portal_series` `ps` ON `ps`.`series_no`=`s`.`series_no` LEFT JOIN `cmf_portal_brand` `pb` ON `pb`.`brand_no`=`b`.`brand_no` LEFT JOIN `cmf_portal_product_content` `pc` ON `pc`.`product_no`=`p`.`product_no` WHERE `cp`.`id` IN ('85','86','87','88','89','90','91','92','93','94','95','96','97','98','99','100','101','102','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','128','129','130','131','132','133','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','154','155','156') AND `p`.`delete_time` = '0' GROUP BY `p`.`id` LIMIT 120,24 [ RunTime:0.731323s ]