SHOW FULL COLUMNS FROM `cmf_portal_category` [ RunTime:0.001377s ]
SELECT * FROM `cmf_portal_category` WHERE `alias` = 'xgpon-module' LIMIT 1 [ RunTime:0.000308s ]
SHOW FULL COLUMNS FROM `cmf_link` [ RunTime:0.001185s ]
SELECT * FROM `cmf_link` WHERE `status` = 1 [ RunTime:0.000318s ]
SHOW FULL COLUMNS FROM `cmf_social` [ RunTime:0.001165s ]
SELECT * FROM `cmf_social` WHERE `status` = 1 [ RunTime:0.000298s ]
SELECT * FROM `cmf_portal_category` WHERE `module_id` = 2 ORDER BY `list_order` ASC [ RunTime:0.000433s ]
SHOW FULL COLUMNS FROM `cmf_countries` [ RunTime:0.000931s ]
SELECT * FROM `cmf_countries` [ RunTime:0.000320s ]
SHOW FULL COLUMNS FROM `cmf_nav_menu` [ RunTime:0.001178s ]
SELECT * FROM `cmf_nav_menu` [ RunTime:0.000579s ]
SELECT * FROM `cmf_portal_category` WHERE `id` = '100' LIMIT 1 [ RunTime:0.000270s ]
SELECT `alias` FROM `cmf_portal_category` WHERE `id` = '100' [ RunTime:0.000162s ]
SHOW FULL COLUMNS FROM `cmf_portal_tag` [ RunTime:0.001026s ]
SELECT `tag`.* FROM `cmf_portal_tag` `tag` INNER JOIN `cmf_portal_tag_post` `tag_post` ON `tag`.`id`=`tag_post`.`tag_id` INNER JOIN `cmf_portal_post` `post` ON `tag_post`.`post_id`=`post`.`id` INNER JOIN `cmf_portal_category_post` `post_category` ON `post`.`id`=`post_category`.`post_id` WHERE `post`.`post_status` = '1' AND `post_category`.`category_id` = '100' GROUP BY `tag`.`id` [ RunTime:0.000492s ]
SHOW FULL COLUMNS FROM `cmf_portal_post` [ RunTime:0.001571s ]
SELECT COUNT(*) AS think_count FROM ( SELECT count(*) AS think_count FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `post_category` ON `post`.`id`=`post_category`.`post_id` LEFT JOIN `cmf_portal_tag_post` `tag_post` ON `post`.`id`=`tag_post`.`post_id` LEFT JOIN `cmf_portal_tag` `tag` ON `tag_post`.`tag_id`=`tag`.`id` WHERE `post`.`post_status` = '1' AND `post_category`.`category_id` = '100' GROUP BY `post`.`id` ) `_group_count_` [ RunTime:0.000550s ]
SELECT `post`.* FROM `cmf_portal_post` `post` INNER JOIN `cmf_portal_category_post` `post_category` ON `post`.`id`=`post_category`.`post_id` LEFT JOIN `cmf_portal_tag_post` `tag_post` ON `post`.`id`=`tag_post`.`post_id` LEFT JOIN `cmf_portal_tag` `tag` ON `tag_post`.`tag_id`=`tag`.`id` WHERE `post`.`post_status` = '1' AND `post_category`.`category_id` = '100' GROUP BY `post`.`id` ORDER BY `post`.`list_order` ASC,`post`.`published_time` DESC LIMIT 0,16 [ RunTime:0.000677s ]
SHOW FULL COLUMNS FROM `cmf_option` [ RunTime:0.001033s ]
SELECT `option_value` FROM `cmf_option` WHERE `option_name` = 'storage' LIMIT 1 [ RunTime:0.000202s ]
SHOW FULL COLUMNS FROM `cmf_review` [ RunTime:0.001234s ]
SELECT COUNT(*) AS think_count FROM `cmf_review` WHERE `product_handle` = 'huawei-xgpon-gpon-olt-class-c-plus-hsc' AND `status` = 1 [ RunTime:0.000506s ]
SELECT AVG(`rating`) AS think_avg FROM `cmf_review` WHERE `product_handle` = 'huawei-xgpon-gpon-olt-class-c-plus-hsc' AND `status` = 1 [ RunTime:0.000548s ]
SELECT AVG(`rating`) AS think_avg FROM `cmf_review` WHERE `product_handle` = 'huawei-xgpon-gpon-olt-class-c-plus-hsc' AND `status` = 1 [ RunTime:0.000504s ]
SHOW FULL COLUMNS FROM `cmf_portal_module_attribute_values` [ RunTime:0.001032s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 3 AND `post_id` = 4228 [ RunTime:0.005591s ]
SELECT `body` FROM `cmf_review` WHERE `product_handle` = 'huawei-xgpon-gpon-olt-class-c-plus-hsc' LIMIT 1 [ RunTime:0.000708s ]
SHOW FULL COLUMNS FROM `cmf_portal_modules` [ RunTime:0.001003s ]
SELECT * FROM `cmf_portal_modules` WHERE `code` = 'product' LIMIT 1 [ RunTime:0.000240s ]
SHOW FULL COLUMNS FROM `cmf_portal_module_attributes` [ RunTime:0.001053s ]
SELECT * FROM `cmf_portal_module_attributes` WHERE `module_id` = 2 ORDER BY `list_order` [ RunTime:0.000328s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 3 AND `module_id` = 2 AND `post_id` = 4228 LIMIT 1 [ RunTime:0.000703s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 4 AND `module_id` = 2 AND `post_id` = 4228 LIMIT 1 [ RunTime:0.006529s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 82 AND `module_id` = 2 AND `post_id` = 4228 LIMIT 1 [ RunTime:0.002312s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 83 AND `module_id` = 2 AND `post_id` = 4228 LIMIT 1 [ RunTime:0.006333s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 5 AND `module_id` = 2 AND `post_id` = 4228 LIMIT 1 [ RunTime:0.006777s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 6 AND `module_id` = 2 AND `post_id` = 4228 LIMIT 1 [ RunTime:0.006889s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 7 AND `module_id` = 2 AND `post_id` = 4228 LIMIT 1 [ RunTime:0.000856s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 8 AND `module_id` = 2 AND `post_id` = 4228 LIMIT 1 [ RunTime:0.006431s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 9 AND `module_id` = 2 AND `post_id` = 4228 LIMIT 1 [ RunTime:0.007110s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 78 AND `module_id` = 2 AND `post_id` = 4228 LIMIT 1 [ RunTime:0.000782s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 80 AND `module_id` = 2 AND `post_id` = 4228 LIMIT 1 [ RunTime:0.006805s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 81 AND `module_id` = 2 AND `post_id` = 4228 LIMIT 1 [ RunTime:0.003443s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 84 AND `module_id` = 2 AND `post_id` = 4228 LIMIT 1 [ RunTime:0.006787s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 85 AND `module_id` = 2 AND `post_id` = 4228 LIMIT 1 [ RunTime:0.006479s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 86 AND `module_id` = 2 AND `post_id` = 4228 LIMIT 1 [ RunTime:0.006539s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 87 AND `module_id` = 2 AND `post_id` = 4228 LIMIT 1 [ RunTime:0.006866s ]
SHOW FULL COLUMNS FROM `cmf_portal_post_attribute_groups` [ RunTime:0.001034s ]
SELECT * FROM `cmf_portal_post_attribute_groups` WHERE `post_id` = 4228 [ RunTime:0.000208s ]
SHOW FULL COLUMNS FROM `cmf_portal_post_attributes_value` [ RunTime:0.001123s ]
SELECT * FROM `cmf_portal_post_attributes_value` WHERE `post_id` = 4228 [ RunTime:0.000269s ]
SELECT COUNT(*) AS think_count FROM `cmf_review` WHERE `product_handle` = 'huawei-original-xgpon-gpon-olt-class-n2a-hsc' AND `status` = 1 [ RunTime:0.000500s ]
SELECT AVG(`rating`) AS think_avg FROM `cmf_review` WHERE `product_handle` = 'huawei-original-xgpon-gpon-olt-class-n2a-hsc' AND `status` = 1 [ RunTime:0.000520s ]
SELECT AVG(`rating`) AS think_avg FROM `cmf_review` WHERE `product_handle` = 'huawei-original-xgpon-gpon-olt-class-n2a-hsc' AND `status` = 1 [ RunTime:0.000498s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 3 AND `post_id` = 4235 [ RunTime:0.007082s ]
SELECT `body` FROM `cmf_review` WHERE `product_handle` = 'huawei-original-xgpon-gpon-olt-class-n2a-hsc' LIMIT 1 [ RunTime:0.000688s ]
SELECT * FROM `cmf_portal_modules` WHERE `code` = 'product' LIMIT 1 [ RunTime:0.000174s ]
SELECT * FROM `cmf_portal_module_attributes` WHERE `module_id` = 2 ORDER BY `list_order` [ RunTime:0.000238s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 3 AND `module_id` = 2 AND `post_id` = 4235 LIMIT 1 [ RunTime:0.000694s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 4 AND `module_id` = 2 AND `post_id` = 4235 LIMIT 1 [ RunTime:0.007164s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 82 AND `module_id` = 2 AND `post_id` = 4235 LIMIT 1 [ RunTime:0.002391s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 83 AND `module_id` = 2 AND `post_id` = 4235 LIMIT 1 [ RunTime:0.006762s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 5 AND `module_id` = 2 AND `post_id` = 4235 LIMIT 1 [ RunTime:0.006406s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 6 AND `module_id` = 2 AND `post_id` = 4235 LIMIT 1 [ RunTime:0.006787s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 7 AND `module_id` = 2 AND `post_id` = 4235 LIMIT 1 [ RunTime:0.000699s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 8 AND `module_id` = 2 AND `post_id` = 4235 LIMIT 1 [ RunTime:0.006038s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 9 AND `module_id` = 2 AND `post_id` = 4235 LIMIT 1 [ RunTime:0.006219s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 78 AND `module_id` = 2 AND `post_id` = 4235 LIMIT 1 [ RunTime:0.000735s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 80 AND `module_id` = 2 AND `post_id` = 4235 LIMIT 1 [ RunTime:0.007064s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 81 AND `module_id` = 2 AND `post_id` = 4235 LIMIT 1 [ RunTime:0.003355s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 84 AND `module_id` = 2 AND `post_id` = 4235 LIMIT 1 [ RunTime:0.006208s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 85 AND `module_id` = 2 AND `post_id` = 4235 LIMIT 1 [ RunTime:0.006220s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 86 AND `module_id` = 2 AND `post_id` = 4235 LIMIT 1 [ RunTime:0.006374s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 87 AND `module_id` = 2 AND `post_id` = 4235 LIMIT 1 [ RunTime:0.006397s ]
SELECT * FROM `cmf_portal_post_attribute_groups` WHERE `post_id` = 4235 [ RunTime:0.000210s ]
SELECT * FROM `cmf_portal_post_attributes_value` WHERE `post_id` = 4235 [ RunTime:0.000206s ]
SELECT COUNT(*) AS think_count FROM `cmf_review` WHERE `product_handle` = 'huawei-original-xgpon-gpon-olt-class-n2a-hsc' AND `status` = 1 [ RunTime:0.000493s ]
SELECT AVG(`rating`) AS think_avg FROM `cmf_review` WHERE `product_handle` = 'huawei-original-xgpon-gpon-olt-class-n2a-hsc' AND `status` = 1 [ RunTime:0.000493s ]
SELECT AVG(`rating`) AS think_avg FROM `cmf_review` WHERE `product_handle` = 'huawei-original-xgpon-gpon-olt-class-n2a-hsc' AND `status` = 1 [ RunTime:0.000490s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 3 AND `post_id` = 4236 [ RunTime:0.006440s ]
SELECT `body` FROM `cmf_review` WHERE `product_handle` = 'huawei-original-xgpon-gpon-olt-class-n2a-hsc' LIMIT 1 [ RunTime:0.000716s ]
SELECT * FROM `cmf_portal_modules` WHERE `code` = 'product' LIMIT 1 [ RunTime:0.000193s ]
SELECT * FROM `cmf_portal_module_attributes` WHERE `module_id` = 2 ORDER BY `list_order` [ RunTime:0.000251s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 3 AND `module_id` = 2 AND `post_id` = 4236 LIMIT 1 [ RunTime:0.000718s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 4 AND `module_id` = 2 AND `post_id` = 4236 LIMIT 1 [ RunTime:0.007089s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 82 AND `module_id` = 2 AND `post_id` = 4236 LIMIT 1 [ RunTime:0.002445s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 83 AND `module_id` = 2 AND `post_id` = 4236 LIMIT 1 [ RunTime:0.006761s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 5 AND `module_id` = 2 AND `post_id` = 4236 LIMIT 1 [ RunTime:0.007801s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 6 AND `module_id` = 2 AND `post_id` = 4236 LIMIT 1 [ RunTime:0.006671s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 7 AND `module_id` = 2 AND `post_id` = 4236 LIMIT 1 [ RunTime:0.000736s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 8 AND `module_id` = 2 AND `post_id` = 4236 LIMIT 1 [ RunTime:0.006468s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 9 AND `module_id` = 2 AND `post_id` = 4236 LIMIT 1 [ RunTime:0.006310s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 78 AND `module_id` = 2 AND `post_id` = 4236 LIMIT 1 [ RunTime:0.000701s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 80 AND `module_id` = 2 AND `post_id` = 4236 LIMIT 1 [ RunTime:0.006409s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 81 AND `module_id` = 2 AND `post_id` = 4236 LIMIT 1 [ RunTime:0.003732s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 84 AND `module_id` = 2 AND `post_id` = 4236 LIMIT 1 [ RunTime:0.006373s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 85 AND `module_id` = 2 AND `post_id` = 4236 LIMIT 1 [ RunTime:0.006383s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 86 AND `module_id` = 2 AND `post_id` = 4236 LIMIT 1 [ RunTime:0.006757s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 87 AND `module_id` = 2 AND `post_id` = 4236 LIMIT 1 [ RunTime:0.007605s ]
SELECT * FROM `cmf_portal_post_attribute_groups` WHERE `post_id` = 4236 [ RunTime:0.000190s ]
SELECT * FROM `cmf_portal_post_attributes_value` WHERE `post_id` = 4236 [ RunTime:0.000237s ]
SELECT COUNT(*) AS think_count FROM `cmf_review` WHERE `product_handle` = 'huawei-xgpon-olt-n2a-hsc' AND `status` = 1 [ RunTime:0.000486s ]
SELECT AVG(`rating`) AS think_avg FROM `cmf_review` WHERE `product_handle` = 'huawei-xgpon-olt-n2a-hsc' AND `status` = 1 [ RunTime:0.000513s ]
SELECT AVG(`rating`) AS think_avg FROM `cmf_review` WHERE `product_handle` = 'huawei-xgpon-olt-n2a-hsc' AND `status` = 1 [ RunTime:0.000480s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 3 AND `post_id` = 4241 [ RunTime:0.006514s ]
SELECT `body` FROM `cmf_review` WHERE `product_handle` = 'huawei-xgpon-olt-n2a-hsc' LIMIT 1 [ RunTime:0.000319s ]
SELECT * FROM `cmf_portal_modules` WHERE `code` = 'product' LIMIT 1 [ RunTime:0.000172s ]
SELECT * FROM `cmf_portal_module_attributes` WHERE `module_id` = 2 ORDER BY `list_order` [ RunTime:0.000235s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 3 AND `module_id` = 2 AND `post_id` = 4241 LIMIT 1 [ RunTime:0.000686s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 4 AND `module_id` = 2 AND `post_id` = 4241 LIMIT 1 [ RunTime:0.007063s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 82 AND `module_id` = 2 AND `post_id` = 4241 LIMIT 1 [ RunTime:0.002660s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 83 AND `module_id` = 2 AND `post_id` = 4241 LIMIT 1 [ RunTime:0.007610s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 5 AND `module_id` = 2 AND `post_id` = 4241 LIMIT 1 [ RunTime:0.006202s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 6 AND `module_id` = 2 AND `post_id` = 4241 LIMIT 1 [ RunTime:0.006461s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 7 AND `module_id` = 2 AND `post_id` = 4241 LIMIT 1 [ RunTime:0.000753s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 8 AND `module_id` = 2 AND `post_id` = 4241 LIMIT 1 [ RunTime:0.007416s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 9 AND `module_id` = 2 AND `post_id` = 4241 LIMIT 1 [ RunTime:0.006360s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 78 AND `module_id` = 2 AND `post_id` = 4241 LIMIT 1 [ RunTime:0.000891s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 80 AND `module_id` = 2 AND `post_id` = 4241 LIMIT 1 [ RunTime:0.007740s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 81 AND `module_id` = 2 AND `post_id` = 4241 LIMIT 1 [ RunTime:0.002840s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 84 AND `module_id` = 2 AND `post_id` = 4241 LIMIT 1 [ RunTime:0.006830s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 85 AND `module_id` = 2 AND `post_id` = 4241 LIMIT 1 [ RunTime:0.006724s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 86 AND `module_id` = 2 AND `post_id` = 4241 LIMIT 1 [ RunTime:0.006352s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 87 AND `module_id` = 2 AND `post_id` = 4241 LIMIT 1 [ RunTime:0.006506s ]
SELECT * FROM `cmf_portal_post_attribute_groups` WHERE `post_id` = 4241 [ RunTime:0.000189s ]
SELECT * FROM `cmf_portal_post_attributes_value` WHERE `post_id` = 4241 [ RunTime:0.000216s ]
SELECT COUNT(*) AS think_count FROM `cmf_review` WHERE `product_handle` = 'huawei-xgpon-olt-n1-hsc' AND `status` = 1 [ RunTime:0.000481s ]
SELECT AVG(`rating`) AS think_avg FROM `cmf_review` WHERE `product_handle` = 'huawei-xgpon-olt-n1-hsc' AND `status` = 1 [ RunTime:0.000492s ]
SELECT AVG(`rating`) AS think_avg FROM `cmf_review` WHERE `product_handle` = 'huawei-xgpon-olt-n1-hsc' AND `status` = 1 [ RunTime:0.000481s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 3 AND `post_id` = 4243 [ RunTime:0.006323s ]
SELECT `body` FROM `cmf_review` WHERE `product_handle` = 'huawei-xgpon-olt-n1-hsc' LIMIT 1 [ RunTime:0.000720s ]
SELECT * FROM `cmf_portal_modules` WHERE `code` = 'product' LIMIT 1 [ RunTime:0.000182s ]
SELECT * FROM `cmf_portal_module_attributes` WHERE `module_id` = 2 ORDER BY `list_order` [ RunTime:0.000256s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 3 AND `module_id` = 2 AND `post_id` = 4243 LIMIT 1 [ RunTime:0.000760s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 4 AND `module_id` = 2 AND `post_id` = 4243 LIMIT 1 [ RunTime:0.006572s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 82 AND `module_id` = 2 AND `post_id` = 4243 LIMIT 1 [ RunTime:0.002413s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 83 AND `module_id` = 2 AND `post_id` = 4243 LIMIT 1 [ RunTime:0.008223s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 5 AND `module_id` = 2 AND `post_id` = 4243 LIMIT 1 [ RunTime:0.006588s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 6 AND `module_id` = 2 AND `post_id` = 4243 LIMIT 1 [ RunTime:0.006363s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 7 AND `module_id` = 2 AND `post_id` = 4243 LIMIT 1 [ RunTime:0.000783s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 8 AND `module_id` = 2 AND `post_id` = 4243 LIMIT 1 [ RunTime:0.006279s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 9 AND `module_id` = 2 AND `post_id` = 4243 LIMIT 1 [ RunTime:0.006721s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 78 AND `module_id` = 2 AND `post_id` = 4243 LIMIT 1 [ RunTime:0.000725s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 80 AND `module_id` = 2 AND `post_id` = 4243 LIMIT 1 [ RunTime:0.006481s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 81 AND `module_id` = 2 AND `post_id` = 4243 LIMIT 1 [ RunTime:0.003155s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 84 AND `module_id` = 2 AND `post_id` = 4243 LIMIT 1 [ RunTime:0.006456s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 85 AND `module_id` = 2 AND `post_id` = 4243 LIMIT 1 [ RunTime:0.006341s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 86 AND `module_id` = 2 AND `post_id` = 4243 LIMIT 1 [ RunTime:0.006429s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 87 AND `module_id` = 2 AND `post_id` = 4243 LIMIT 1 [ RunTime:0.006521s ]
SELECT * FROM `cmf_portal_post_attribute_groups` WHERE `post_id` = 4243 [ RunTime:0.000187s ]
SELECT * FROM `cmf_portal_post_attributes_value` WHERE `post_id` = 4243 [ RunTime:0.000205s ]
SELECT COUNT(*) AS think_count FROM `cmf_review` WHERE `product_handle` = 'zte-xgpon-olt-n2a' AND `status` = 1 [ RunTime:0.000462s ]
SELECT AVG(`rating`) AS think_avg FROM `cmf_review` WHERE `product_handle` = 'zte-xgpon-olt-n2a' AND `status` = 1 [ RunTime:0.000469s ]
SELECT AVG(`rating`) AS think_avg FROM `cmf_review` WHERE `product_handle` = 'zte-xgpon-olt-n2a' AND `status` = 1 [ RunTime:0.000470s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 3 AND `post_id` = 4272 [ RunTime:0.006361s ]
SELECT `body` FROM `cmf_review` WHERE `product_handle` = 'zte-xgpon-olt-n2a' LIMIT 1 [ RunTime:0.000700s ]
SELECT * FROM `cmf_portal_modules` WHERE `code` = 'product' LIMIT 1 [ RunTime:0.000182s ]
SELECT * FROM `cmf_portal_module_attributes` WHERE `module_id` = 2 ORDER BY `list_order` [ RunTime:0.000264s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 3 AND `module_id` = 2 AND `post_id` = 4272 LIMIT 1 [ RunTime:0.000794s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 4 AND `module_id` = 2 AND `post_id` = 4272 LIMIT 1 [ RunTime:0.006825s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 82 AND `module_id` = 2 AND `post_id` = 4272 LIMIT 1 [ RunTime:0.002512s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 83 AND `module_id` = 2 AND `post_id` = 4272 LIMIT 1 [ RunTime:0.006561s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 5 AND `module_id` = 2 AND `post_id` = 4272 LIMIT 1 [ RunTime:0.007146s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 6 AND `module_id` = 2 AND `post_id` = 4272 LIMIT 1 [ RunTime:0.006551s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 7 AND `module_id` = 2 AND `post_id` = 4272 LIMIT 1 [ RunTime:0.000855s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 8 AND `module_id` = 2 AND `post_id` = 4272 LIMIT 1 [ RunTime:0.007032s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 9 AND `module_id` = 2 AND `post_id` = 4272 LIMIT 1 [ RunTime:0.006532s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 78 AND `module_id` = 2 AND `post_id` = 4272 LIMIT 1 [ RunTime:0.000792s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 80 AND `module_id` = 2 AND `post_id` = 4272 LIMIT 1 [ RunTime:0.006272s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 81 AND `module_id` = 2 AND `post_id` = 4272 LIMIT 1 [ RunTime:0.002920s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 84 AND `module_id` = 2 AND `post_id` = 4272 LIMIT 1 [ RunTime:0.006862s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 85 AND `module_id` = 2 AND `post_id` = 4272 LIMIT 1 [ RunTime:0.006700s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 86 AND `module_id` = 2 AND `post_id` = 4272 LIMIT 1 [ RunTime:0.006732s ]
SELECT * FROM `cmf_portal_module_attribute_values` WHERE `attribute_id` = 87 AND `module_id` = 2 AND `post_id` = 4272 LIMIT 1 [ RunTime:0.006504s ]
SELECT * FROM `cmf_portal_post_attribute_groups` WHERE `post_id` = 4272 [ RunTime:0.000177s ]
SELECT * FROM `cmf_portal_post_attributes_value` WHERE `post_id` = 4272 [ RunTime:0.000217s ]
SELECT `post_id` FROM `cmf_portal_module_attribute_values` WHERE `attribute_name` = 'types' AND `value` LIKE '%Sale%' [ RunTime:0.007534s ]
SELECT * FROM `cmf_portal_post` WHERE `id` IN ('4097','4129','4251','4254') [ RunTime:0.000378s ]
SHOW FULL COLUMNS FROM `cmf_theme_file` [ RunTime:0.001195s ]
SELECT * FROM `cmf_theme_file` WHERE `theme` = 'default' AND `file` = 'portal/404' LIMIT 1 [ RunTime:0.000336s ]
SELECT `more`,`file`,`id`,`is_public` FROM `cmf_theme_file` WHERE `theme` = 'default' AND ( `is_public` = 1 OR `file` = 'portal/category' ) ORDER BY `is_public` DESC [ RunTime:0.000319s ]
SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000739s ]
SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 1 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000646s ]
SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 2 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000418s ]
SELECT * FROM `cmf_nav_menu` WHERE `nav_id` = 2 AND `status` = 1 ORDER BY `list_order` ASC [ RunTime:0.000319s ]