[ 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 ('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84') AND `p`.`delete_time` = '0' GROUP BY `p`.`id` ) `_group_count_` [ RunTime:0.286144s ]
[ 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 ('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84') AND `p`.`delete_time` = '0' GROUP BY `p`.`id` LIMIT 96,24 [ RunTime:0.556662s ]