SELECT `more`,`file`,`id` FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND ( `is_public` = 1 OR `file` = 'portal/products/list_product' ) ORDER BY `is_public` DESC [ RunTime:0.000339s ]
SELECT * FROM `cmf_product_category` WHERE `status` = 1 AND `delete_time` = 0 ORDER BY `level` ASC,`list_order` ASC,`id` ASC [ RunTime:0.000424s ]
SHOW FULL COLUMNS FROM `cmf_product_category_relation` [ RunTime:0.001026s ]
SELECT relation.category_id AS menu_category_id,`product`.`id`,`product`.`name`,`product`.`thumbnail`,`product`.`published_time`,`product`.`list_order`,primary_category.alias AS primary_category_alias FROM `cmf_product_category_relation` `relation` INNER JOIN `cmf_product` `product` ON `product`.`id`=`relation`.`product_id` INNER JOIN `cmf_product_category` `relation_category` ON `relation_category`.`id`=`relation`.`category_id` INNER JOIN `cmf_product_category` `primary_category` ON `primary_category`.`id`=`product`.`primary_category_id` LEFT JOIN `cmf_product_category` `primary_parent` ON `primary_parent`.`id`=`primary_category`.`parent_id` WHERE `relation`.`category_id` IN ('21','30','23','24','25','26','10','11','12','15','4','16','17','18','19','20','13','14','8','2','22','27','28','29') AND `relation_category`.`status` = '1' AND `relation_category`.`delete_time` = '0' AND `product`.`status` = '1' AND `product`.`delete_time` = '0' AND `primary_category`.`status` = '1' AND `primary_category`.`delete_time` = '0' AND ( (primary_category.parent_id IS NULL OR (primary_parent.status=1 AND primary_parent.delete_time=0)) ) ORDER BY `relation`.`category_id` ASC,`product`.`list_order` ASC,`product`.`published_time` DESC,`product`.`id` DESC [ RunTime:0.003414s ]
SHOW FULL COLUMNS FROM `cmf_product_attribute_value` [ RunTime:0.000985s ]
SELECT `value`.`product_id`,`value`.`attribute_id`,`attribute`.`name`,`value`.`raw_value`,`attribute`.`unit` FROM `cmf_product_attribute_value` `value` INNER JOIN `cmf_product_filter_attribute` `attribute` ON `attribute`.`id`=`value`.`attribute_id` WHERE `value`.`product_id` IN ('431','430','429','426','490','265','264','263','406','405','404','403','178','179','180','181','149','150','151','152','191','192','193','194','397','396','395','394','496','495','494','493','530','529','528','527','276','275','274','273','281','280','279','278','286','285','284','283','291','290','289','288','293','292','518','517','516','515','511','510','509','508','4','5','6','7','126','125','124','123','136','135','134','133','148','147','146','145','499','498','497','461','467','466','465','464','489','488','487','486','542','541','540','539') AND `value`.`raw_value` <> '' AND `attribute`.`status` = '1' AND `attribute`.`delete_time` = '0' ORDER BY `value`.`product_id` ASC,`value`.`attribute_id` ASC,`value`.`list_order` ASC,`value`.`id` ASC [ RunTime:0.004674s ]
SHOW FULL COLUMNS FROM `cmf_portal_category` [ RunTime:0.001221s ]
SELECT * FROM `cmf_portal_category` WHERE `parent_id` = 3 AND `status` = 1 AND `front_page` = 1 AND `delete_time` = 0 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000500s ]
SHOW FULL COLUMNS FROM `cmf_portal_post` [ RunTime:0.001183s ]
SELECT `post`.`id`,`post`.`post_title`,`post`.`thumbnail`,`post`.`more`,`post`.`published_time`,`relation`.`category_id`,`relation`.`list_order` FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `relation` ON `relation`.`post_id`=`post`.`id` WHERE `relation`.`category_id` IN ('36','37','38','39','40','41','42','43','44','45','46','47','48','49') AND `relation`.`status` = '1' AND `post`.`post_type` = '1' AND `post`.`post_status` = '1' AND `post`.`delete_time` = '0' AND `post`.`published_time` > '0' AND `post`.`published_time` <= '1794931223' ORDER BY `relation`.`category_id` ASC,`relation`.`list_order` ASC,`post`.`published_time` DESC,`post`.`id` DESC [ RunTime:0.000611s ]
SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND ( `parent_id` = 0 AND `id` IN (5,6,7) ) ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000407s ]
SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 5 AND `front_page` = 1 ORDER BY `list_order` ASC,`id` ASC LIMIT 20 [ RunTime:0.000373s ]
SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 6 AND `front_page` = 1 ORDER BY `list_order` ASC,`id` ASC LIMIT 20 [ RunTime:0.000381s ]
SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 7 AND `front_page` = 1 ORDER BY `list_order` ASC,`id` ASC LIMIT 20 [ RunTime:0.000369s ]
SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND ( `parent_id` = 0 AND `id` IN (5,6,7) ) ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000329s ]
SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 5 AND `front_page` = 1 ORDER BY `list_order` ASC,`id` ASC LIMIT 20 [ RunTime:0.000374s ]
SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 6 AND `front_page` = 1 ORDER BY `list_order` ASC,`id` ASC LIMIT 20 [ RunTime:0.000344s ]
SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 7 AND `front_page` = 1 ORDER BY `list_order` ASC,`id` ASC LIMIT 20 [ RunTime:0.000423s ]
SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`post_status` = '1' AND `post`.`post_type` = '1' AND `post`.`delete_time` = '0' ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1794931223' ) AND ( `category_post`.`category_id` = '50' ) GROUP BY `post`.`id` ORDER BY `list_order` ASC,`post`.`published_time` DESC,`post`.`id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND ( `parent_id` = 0 AND `id` IN (5,6,7) ) ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000355s ]
SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 5 AND `front_page` = 1 ORDER BY `list_order` ASC,`id` ASC LIMIT 20 [ RunTime:0.000348s ]
SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 6 AND `front_page` = 1 ORDER BY `list_order` ASC,`id` ASC LIMIT 20 [ RunTime:0.000359s ]
SELECT * FROM `cmf_portal_category` WHERE `status` = 1 AND `delete_time` = 0 AND `parent_id` = 7 AND `front_page` = 1 ORDER BY `list_order` ASC,`id` ASC LIMIT 20 [ RunTime:0.000340s ]
SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`post_status` = '1' AND `post`.`post_type` = '1' AND `post`.`delete_time` = '0' ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1794931223' ) AND ( `category_post`.`category_id` = '50' ) GROUP BY `post`.`id` ORDER BY `list_order` ASC,`post`.`published_time` DESC,`post`.`id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT post.*,min(category_post.category_id) as category_id FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `category_post` ON `post`.`id`=`category_post`.`post_id` WHERE ( `post`.`post_status` = '1' AND `post`.`post_type` = '1' AND `post`.`delete_time` = '0' ) AND ( `post`.`published_time` > '0' AND `post`.`published_time` < '1794931223' ) AND ( `category_post`.`category_id` = '30' ) GROUP BY `post`.`id` ORDER BY `list_order` ASC,`post`.`published_time` DESC,`post`.`id` DESC LIMIT 99 [ RunTime:0.000458s ]