SHOW FULL COLUMNS FROM `cmf_product` [ RunTime:0.001347s ]
SELECT * FROM `cmf_product` WHERE `id` = 329 AND `status` = 1 AND `delete_time` = 0 LIMIT 1 [ RunTime:0.000358s ]
SHOW FULL COLUMNS FROM `cmf_product_category` [ RunTime:0.000994s ]
SELECT * FROM `cmf_product_category` WHERE `id` = 13 AND `status` = 1 AND `delete_time` = 0 LIMIT 1 [ RunTime:0.000295s ]
SHOW FULL COLUMNS FROM `cmf_option` [ RunTime:0.000793s ]
SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.000196s ]
SHOW FULL COLUMNS FROM `cmf_product_recommendation` [ RunTime:0.000776s ]
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` = '329' 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.000435s ]
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` <> '329' 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.000376s ]
SHOW FULL COLUMNS FROM `cmf_product_attribute_value` [ RunTime:0.000837s ]
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.000337s ]
SHOW FULL COLUMNS FROM `cmf_product_custom_attribute` [ RunTime:0.000843s ]
SELECT * FROM `cmf_product_custom_attribute` WHERE `product_id` = 294 AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000267s ]
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.000299s ]
SELECT * FROM `cmf_product_custom_attribute` WHERE `product_id` = 295 AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000250s ]
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.000268s ]
SELECT * FROM `cmf_product_custom_attribute` WHERE `product_id` = 296 AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000237s ]
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.000280s ]
SELECT * FROM `cmf_product_custom_attribute` WHERE `product_id` = 297 AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000217s ]
SHOW FULL COLUMNS FROM `cmf_product_application_relation` [ RunTime:0.000778s ]
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 ('329','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.000443s ]
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 ('329','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.000330s ]
SHOW FULL COLUMNS FROM `cmf_product_accessory_relation` [ RunTime:0.000773s ]
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 ('329','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.000340s ]
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` = '329' AND `value`.`raw_value` <> '' AND `attribute`.`status` = '1' AND `attribute`.`delete_time` = '0' ORDER BY `value`.`list_order` ASC,`value`.`id` ASC [ RunTime:0.000305s ]
SELECT * FROM `cmf_product_custom_attribute` WHERE `product_id` = 329 AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000228s ]
SHOW FULL COLUMNS FROM `cmf_product_content_block` [ RunTime:0.000825s ]
SELECT * FROM `cmf_product_content_block` WHERE `product_id` = 329 AND `status` = 1 ORDER BY `list_order` ASC,`id` ASC [ RunTime:0.000289s ]
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` = '329' AND `application`.`status` = '1' AND `application`.`delete_time` = '0' ORDER BY `relation`.`list_order` ASC,`application`.`id` ASC [ RunTime:0.000409s ]
SHOW FULL COLUMNS FROM `cmf_theme_file` [ RunTime:0.000948s ]
SELECT * FROM `cmf_theme_file` WHERE `theme` = 'simpleboot3' AND `file` = 'portal/about/list_joinus' LIMIT 1 [ RunTime:0.000237s ]
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.000269s ]
SELECT * FROM `cmf_product_category` WHERE `status` = 1 AND `delete_time` = 0 ORDER BY `level` ASC,`list_order` ASC,`id` ASC [ RunTime:0.000491s ]
SHOW FULL COLUMNS FROM `cmf_product_category_relation` [ RunTime:0.000889s ]
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.003337s ]
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.003726s ]
SHOW FULL COLUMNS FROM `cmf_portal_category` [ RunTime:0.001170s ]
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.000460s ]
SHOW FULL COLUMNS FROM `cmf_portal_post` [ RunTime:0.001184s ]
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` <= '1794936696' ORDER BY `relation`.`category_id` ASC,`relation`.`list_order` ASC,`post`.`published_time` DESC,`post`.`id` DESC [ RunTime:0.000606s ]
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.000376s ]
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.000373s ]
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.000352s ]
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.000331s ]
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.000360s ]
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.000372s ]
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` < '1794936696' ) 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.000467s ]
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.000332s ]
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.000348s ]
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.000358s ]
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` < '1794936696' ) 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.000420s ]
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` < '1794936696' ) 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.000436s ]