SHOW FULL COLUMNS FROM `cmf_product` [ RunTime:0.001320s ]
SELECT * FROM `cmf_product` WHERE `id` = 233 AND `status` = 1 AND `delete_time` = 0 LIMIT 1 [ RunTime:0.000429s ]
SHOW FULL COLUMNS FROM `cmf_product_category` [ RunTime:0.001485s ]
SELECT * FROM `cmf_product_category` WHERE `id` = 15 AND `status` = 1 AND `delete_time` = 0 LIMIT 1 [ RunTime:0.000358s ]
SHOW FULL COLUMNS FROM `cmf_option` [ RunTime:0.000824s ]
SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.000210s ]
SHOW FULL COLUMNS FROM `cmf_product_recommendation` [ RunTime:0.000867s ]
SELECT `recommended`.`id`,`recommended`.`name`,`recommended`.`description`,`recommended`.`thumbnail`,`recommended`.`detail_template`,primary_category.alias AS primary_category_alias FROM `cmf_product_recommendation` `relation` INNER JOIN `cmf_product` `recommended` ON `recommended`.`id`=`relation`.`recommended_product_id` INNER JOIN `cmf_product_category` `primary_category` ON `primary_category`.`id`=`recommended`.`primary_category_id` LEFT JOIN `cmf_product_category` `primary_parent` ON `primary_parent`.`id`=`primary_category`.`parent_id` WHERE `relation`.`product_id` = '233' AND `recommended`.`status` = '1' AND `recommended`.`delete_time` = '0' AND `primary_category`.`status` = '1' AND `primary_category`.`delete_time` = '0' AND ( (primary_category.parent_id IS NULL OR primary_category.parent_id=0 OR (primary_parent.status=1 AND primary_parent.delete_time=0)) ) ORDER BY `relation`.`list_order` ASC,`recommended`.`id` ASC [ RunTime:0.000517s ]
SELECT `recommended`.`id`,`recommended`.`name`,`recommended`.`description`,`recommended`.`thumbnail`,`recommended`.`detail_template`,primary_category.alias AS primary_category_alias FROM `cmf_product` `recommended` INNER JOIN `cmf_product_category` `primary_category` ON `primary_category`.`id`=`recommended`.`primary_category_id` LEFT JOIN `cmf_product_category` `primary_parent` ON `primary_parent`.`id`=`primary_category`.`parent_id` WHERE `recommended`.`primary_category_id` = '15' AND `recommended`.`id` <> '233' AND `recommended`.`status` = '1' AND `recommended`.`delete_time` = '0' AND `primary_category`.`status` = '1' AND `primary_category`.`delete_time` = '0' AND ( (primary_category.parent_id IS NULL OR primary_category.parent_id=0 OR (primary_parent.status=1 AND primary_parent.delete_time=0)) ) ORDER BY `recommended`.`list_order` ASC,`recommended`.`id` ASC LIMIT 4 [ RunTime:0.000499s ]
SHOW FULL COLUMNS FROM `cmf_product_attribute_value` [ RunTime:0.000943s ]
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` = '199' AND `value`.`raw_value` <> '' AND `attribute`.`status` = '1' AND `attribute`.`delete_time` = '0' ORDER BY `value`.`list_order` ASC,`value`.`id` ASC [ RunTime:0.000490s ]
SHOW FULL COLUMNS FROM `cmf_product_custom_attribute` [ RunTime:0.001149s ]
SELECT * FROM `cmf_product_custom_attribute` WHERE `product_id` = 199 AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000342s ]
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` = '200' AND `value`.`raw_value` <> '' AND `attribute`.`status` = '1' AND `attribute`.`delete_time` = '0' ORDER BY `value`.`list_order` ASC,`value`.`id` ASC [ RunTime:0.000478s ]
SELECT * FROM `cmf_product_custom_attribute` WHERE `product_id` = 200 AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000320s ]
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` = '201' AND `value`.`raw_value` <> '' AND `attribute`.`status` = '1' AND `attribute`.`delete_time` = '0' ORDER BY `value`.`list_order` ASC,`value`.`id` ASC [ RunTime:0.000425s ]
SELECT * FROM `cmf_product_custom_attribute` WHERE `product_id` = 201 AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000307s ]
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` = '202' AND `value`.`raw_value` <> '' AND `attribute`.`status` = '1' AND `attribute`.`delete_time` = '0' ORDER BY `value`.`list_order` ASC,`value`.`id` ASC [ RunTime:0.000421s ]
SELECT * FROM `cmf_product_custom_attribute` WHERE `product_id` = 202 AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000306s ]
SHOW FULL COLUMNS FROM `cmf_product_application_relation` [ RunTime:0.001101s ]
SELECT `relation`.`product_id`,`application`.`id`,`application`.`name`,`application`.`description`,`application`.`thumbnail`,`application`.`thumbnail_mobile` FROM `cmf_product_application_relation` `relation` INNER JOIN `cmf_product_application` `application` ON `application`.`id`=`relation`.`application_id` WHERE `relation`.`product_id` IN ('233','199','200','201','202') AND `application`.`status` = '1' AND `application`.`delete_time` = '0' ORDER BY `relation`.`product_id` ASC,`relation`.`list_order` ASC,`application`.`id` ASC [ RunTime:0.000500s ]
SELECT `relation`.`product_id`,`product`.`id`,`product`.`name`,`product`.`description`,`product`.`thumbnail`,`product`.`detail_template`,`product`.`primary_category_id` FROM `cmf_product_recommendation` `relation` INNER JOIN `cmf_product` `product` ON `product`.`id`=`relation`.`recommended_product_id` WHERE `relation`.`product_id` IN ('233','199','200','201','202') AND `product`.`status` = '1' AND `product`.`delete_time` = '0' ORDER BY `relation`.`product_id` ASC,`relation`.`list_order` ASC,`product`.`id` ASC [ RunTime:0.000391s ]
SHOW FULL COLUMNS FROM `cmf_product_accessory_relation` [ RunTime:0.000849s ]
SELECT `relation`.`product_id`,`product`.`id`,`product`.`name`,`product`.`description`,`product`.`thumbnail`,`product`.`detail_template`,`product`.`primary_category_id` FROM `cmf_product_accessory_relation` `relation` INNER JOIN `cmf_product` `product` ON `product`.`id`=`relation`.`accessory_product_id` WHERE `relation`.`product_id` IN ('233','199','200','201','202') AND `product`.`status` = '1' AND `product`.`delete_time` = '0' ORDER BY `relation`.`product_id` ASC,`relation`.`list_order` ASC,`product`.`id` ASC [ RunTime:0.000413s ]
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` = '233' AND `value`.`raw_value` <> '' AND `attribute`.`status` = '1' AND `attribute`.`delete_time` = '0' ORDER BY `value`.`list_order` ASC,`value`.`id` ASC [ RunTime:0.000385s ]
SELECT * FROM `cmf_product_custom_attribute` WHERE `product_id` = 233 AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000333s ]
SHOW FULL COLUMNS FROM `cmf_product_content_block` [ RunTime:0.000990s ]
SELECT * FROM `cmf_product_content_block` WHERE `product_id` = 233 AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000431s ]
SELECT `application`.`id`,`application`.`name`,`application`.`description`,`application`.`thumbnail`,`application`.`thumbnail_mobile` FROM `cmf_product_application_relation` `relation` INNER JOIN `cmf_product_application` `application` ON `application`.`id`=`relation`.`application_id` WHERE `relation`.`product_id` = '233' AND `application`.`status` = '1' AND `application`.`delete_time` = '0' ORDER BY `relation`.`list_order` ASC,`application`.`id` ASC [ RunTime:0.000450s ]
SHOW FULL COLUMNS FROM `cmf_theme_file` [ RunTime:0.001255s ]
SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/about/list_joinus' LIMIT 1 [ RunTime:0.000315s ]
SELECT `more`,`file`,`id` FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND ( `is_public` = 1 OR `file` = 'portal/products/product_detail' ) ORDER BY `is_public` DESC [ RunTime:0.000298s ]
SELECT * FROM `cmf_product_category` WHERE `status` = 1 AND `delete_time` = 0 ORDER BY `level` ASC,`list_order` ASC,`id` ASC [ RunTime:0.000388s ]
SHOW FULL COLUMNS FROM `cmf_product_category_relation` [ RunTime:0.000953s ]
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.003361s ]
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.003716s ]
SHOW FULL COLUMNS FROM `cmf_portal_category` [ RunTime:0.001270s ]
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.000432s ]
SHOW FULL COLUMNS FROM `cmf_portal_post` [ RunTime:0.001201s ]
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` <= '1794836181' ORDER BY `relation`.`category_id` ASC,`relation`.`list_order` ASC,`post`.`published_time` DESC,`post`.`id` DESC [ RunTime:0.000586s ]
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.000366s ]
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.000397s ]
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.000362s ]
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.000396s ]
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.000334s ]
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.000356s ]
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.000371s ]
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.000354s ]
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` < '1794836181' ) 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.000442s ]
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.000386s ]
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.000351s ]
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.000378s ]
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.000336s ]
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` < '1794836181' ) 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.000421s ]
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` < '1794836181' ) 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.000455s ]