SHOW FULL COLUMNS FROM `cmf_product` [ RunTime:0.001377s ]
SELECT * FROM `cmf_product` WHERE `id` = 488 AND `status` = 1 AND `delete_time` = 0 LIMIT 1 [ RunTime:0.000350s ]
SHOW FULL COLUMNS FROM `cmf_product_category` [ RunTime:0.001020s ]
SELECT * FROM `cmf_product_category` WHERE `id` = 29 AND `status` = 1 AND `delete_time` = 0 LIMIT 1 [ RunTime:0.000295s ]
SELECT * FROM `cmf_product_category` WHERE `id` = 6 AND `status` = 1 AND `delete_time` = 0 LIMIT 1 [ RunTime:0.000216s ]
SHOW FULL COLUMNS FROM `cmf_option` [ RunTime:0.000819s ]
SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.000215s ]
SHOW FULL COLUMNS FROM `cmf_product_recommendation` [ RunTime:0.000806s ]
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` = '488' 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.000447s ]
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` = '29' AND `recommended`.`id` <> '488' 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.000379s ]
SHOW FULL COLUMNS FROM `cmf_product_attribute_value` [ RunTime:0.000872s ]
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` = '468' AND `value`.`raw_value` <> '' AND `attribute`.`status` = '1' AND `attribute`.`delete_time` = '0' ORDER BY `value`.`list_order` ASC,`value`.`id` ASC [ RunTime:0.000342s ]
SHOW FULL COLUMNS FROM `cmf_product_custom_attribute` [ RunTime:0.000837s ]
SELECT * FROM `cmf_product_custom_attribute` WHERE `product_id` = 468 AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000278s ]
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` = '469' AND `value`.`raw_value` <> '' AND `attribute`.`status` = '1' AND `attribute`.`delete_time` = '0' ORDER BY `value`.`list_order` ASC,`value`.`id` ASC [ RunTime:0.000281s ]
SELECT * FROM `cmf_product_custom_attribute` WHERE `product_id` = 469 AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000243s ]
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` = '470' AND `value`.`raw_value` <> '' AND `attribute`.`status` = '1' AND `attribute`.`delete_time` = '0' ORDER BY `value`.`list_order` ASC,`value`.`id` ASC [ RunTime:0.000275s ]
SELECT * FROM `cmf_product_custom_attribute` WHERE `product_id` = 470 AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000218s ]
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` = '471' AND `value`.`raw_value` <> '' AND `attribute`.`status` = '1' AND `attribute`.`delete_time` = '0' ORDER BY `value`.`list_order` ASC,`value`.`id` ASC [ RunTime:0.000275s ]
SELECT * FROM `cmf_product_custom_attribute` WHERE `product_id` = 471 AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000226s ]
SHOW FULL COLUMNS FROM `cmf_product_application_relation` [ RunTime:0.000762s ]
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 ('488','468','469','470','471') AND `application`.`status` = '1' AND `application`.`delete_time` = '0' ORDER BY `relation`.`product_id` ASC,`relation`.`list_order` ASC,`application`.`id` ASC [ RunTime:0.000341s ]
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 ('488','468','469','470','471') AND `product`.`status` = '1' AND `product`.`delete_time` = '0' ORDER BY `relation`.`product_id` ASC,`relation`.`list_order` ASC,`product`.`id` ASC [ RunTime:0.000329s ]
SHOW FULL COLUMNS FROM `cmf_product_accessory_relation` [ RunTime:0.000767s ]
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 ('488','468','469','470','471') AND `product`.`status` = '1' AND `product`.`delete_time` = '0' ORDER BY `relation`.`product_id` ASC,`relation`.`list_order` ASC,`product`.`id` ASC [ RunTime:0.000353s ]
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` = '488' AND `value`.`raw_value` <> '' AND `attribute`.`status` = '1' AND `attribute`.`delete_time` = '0' ORDER BY `value`.`list_order` ASC,`value`.`id` ASC [ RunTime:0.000275s ]
SELECT * FROM `cmf_product_custom_attribute` WHERE `product_id` = 488 AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000232s ]
SHOW FULL COLUMNS FROM `cmf_product_content_block` [ RunTime:0.000809s ]
SELECT * FROM `cmf_product_content_block` WHERE `product_id` = 488 AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000284s ]
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` = '488' AND `application`.`status` = '1' AND `application`.`delete_time` = '0' ORDER BY `relation`.`list_order` ASC,`application`.`id` ASC [ RunTime:0.000350s ]
SHOW FULL COLUMNS FROM `cmf_theme_file` [ RunTime:0.001055s ]
SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/about/list_joinus' LIMIT 1 [ RunTime:0.000258s ]
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.000286s ]
SELECT * FROM `cmf_product_category` WHERE `status` = 1 AND `delete_time` = 0 ORDER BY `level` ASC,`list_order` ASC,`id` ASC [ RunTime:0.000448s ]
SHOW FULL COLUMNS FROM `cmf_product_category_relation` [ RunTime:0.001041s ]
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.003375s ]
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.003928s ]
SHOW FULL COLUMNS FROM `cmf_portal_category` [ RunTime:0.001266s ]
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.000454s ]
SHOW FULL COLUMNS FROM `cmf_portal_post` [ RunTime:0.001200s ]
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` <= '1794934103' ORDER BY `relation`.`category_id` ASC,`relation`.`list_order` ASC,`post`.`published_time` DESC,`post`.`id` DESC [ RunTime:0.000632s ]
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.000370s ]
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.000388s ]
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.000379s ]
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.000367s ]
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.000343s ]
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.000358s ]
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.000367s ]
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.000356s ]
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` < '1794934103' ) 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.000462s ]
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.000338s ]
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.000363s ]
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.000361s ]
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.000368s ]
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` < '1794934103' ) 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.000402s ]
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` < '1794934103' ) 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.000445s ]