SHOW FULL COLUMNS FROM `cmf_product` [ RunTime:0.001413s ]
SELECT * FROM `cmf_product` WHERE `id` = 375 AND `status` = 1 AND `delete_time` = 0 LIMIT 1 [ RunTime:0.000392s ]
SHOW FULL COLUMNS FROM `cmf_product_category` [ RunTime:0.001017s ]
SELECT * FROM `cmf_product_category` WHERE `id` = 13 AND `status` = 1 AND `delete_time` = 0 LIMIT 1 [ RunTime:0.000311s ]
SHOW FULL COLUMNS FROM `cmf_option` [ RunTime:0.000800s ]
SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.000206s ]
SHOW FULL COLUMNS FROM `cmf_product_recommendation` [ RunTime:0.000781s ]
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` = '375' 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.000438s ]
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` = '13' AND `recommended`.`id` <> '375' 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.000393s ]
SHOW FULL COLUMNS FROM `cmf_product_attribute_value` [ RunTime:0.000854s ]
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` = '294' AND `value`.`raw_value` <> '' AND `attribute`.`status` = '1' AND `attribute`.`delete_time` = '0' ORDER BY `value`.`list_order` ASC,`value`.`id` ASC [ RunTime:0.000351s ]
SHOW FULL COLUMNS FROM `cmf_product_custom_attribute` [ RunTime:0.000834s ]
SELECT * FROM `cmf_product_custom_attribute` WHERE `product_id` = 294 AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000299s ]
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` = '295' AND `value`.`raw_value` <> '' AND `attribute`.`status` = '1' AND `attribute`.`delete_time` = '0' ORDER BY `value`.`list_order` ASC,`value`.`id` ASC [ RunTime:0.000292s ]
SELECT * FROM `cmf_product_custom_attribute` WHERE `product_id` = 295 AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000241s ]
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` = '296' AND `value`.`raw_value` <> '' AND `attribute`.`status` = '1' AND `attribute`.`delete_time` = '0' ORDER BY `value`.`list_order` ASC,`value`.`id` ASC [ RunTime:0.000284s ]
SELECT * FROM `cmf_product_custom_attribute` WHERE `product_id` = 296 AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000222s ]
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` = '297' AND `value`.`raw_value` <> '' AND `attribute`.`status` = '1' AND `attribute`.`delete_time` = '0' ORDER BY `value`.`list_order` ASC,`value`.`id` ASC [ RunTime:0.000276s ]
SELECT * FROM `cmf_product_custom_attribute` WHERE `product_id` = 297 AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000247s ]
SHOW FULL COLUMNS FROM `cmf_product_application_relation` [ RunTime:0.000756s ]
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 ('375','294','295','296','297') AND `application`.`status` = '1' AND `application`.`delete_time` = '0' ORDER BY `relation`.`product_id` ASC,`relation`.`list_order` ASC,`application`.`id` ASC [ RunTime:0.000450s ]
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 ('375','294','295','296','297') AND `product`.`status` = '1' AND `product`.`delete_time` = '0' ORDER BY `relation`.`product_id` ASC,`relation`.`list_order` ASC,`product`.`id` ASC [ RunTime:0.000344s ]
SHOW FULL COLUMNS FROM `cmf_product_accessory_relation` [ RunTime:0.000754s ]
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 ('375','294','295','296','297') AND `product`.`status` = '1' AND `product`.`delete_time` = '0' ORDER BY `relation`.`product_id` ASC,`relation`.`list_order` ASC,`product`.`id` ASC [ RunTime:0.000357s ]
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` = '375' AND `value`.`raw_value` <> '' AND `attribute`.`status` = '1' AND `attribute`.`delete_time` = '0' ORDER BY `value`.`list_order` ASC,`value`.`id` ASC [ RunTime:0.000310s ]
SELECT * FROM `cmf_product_custom_attribute` WHERE `product_id` = 375 AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000244s ]
SHOW FULL COLUMNS FROM `cmf_product_content_block` [ RunTime:0.000846s ]
SELECT * FROM `cmf_product_content_block` WHERE `product_id` = 375 AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000283s ]
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` = '375' AND `application`.`status` = '1' AND `application`.`delete_time` = '0' ORDER BY `relation`.`list_order` ASC,`application`.`id` ASC [ RunTime:0.000457s ]
SHOW FULL COLUMNS FROM `cmf_theme_file` [ RunTime:0.001085s ]
SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/about/list_joinus' LIMIT 1 [ RunTime:0.000265s ]
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.000300s ]
SELECT * FROM `cmf_product_category` WHERE `status` = 1 AND `delete_time` = 0 ORDER BY `level` ASC,`list_order` ASC,`id` ASC [ RunTime:0.000477s ]
SHOW FULL COLUMNS FROM `cmf_product_category_relation` [ RunTime:0.001000s ]
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.003598s ]
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.003902s ]
SHOW FULL COLUMNS FROM `cmf_portal_category` [ RunTime:0.001418s ]
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.000637s ]
SHOW FULL COLUMNS FROM `cmf_portal_post` [ RunTime:0.001419s ]
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` <= '1794833986' ORDER BY `relation`.`category_id` ASC,`relation`.`list_order` ASC,`post`.`published_time` DESC,`post`.`id` DESC [ RunTime:0.000694s ]
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.000446s ]
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.000457s ]
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.000448s ]
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.000456s ]
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.000421s ]
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.000447s ]
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.000450s ]
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.000453s ]
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` < '1794833986' ) 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.000556s ]
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.000424s ]
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.000444s ]
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.000442s ]
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.000444s ]
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` < '1794833986' ) 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.000502s ]
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` < '1794833986' ) 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.000503s ]