SHOW FULL COLUMNS FROM `db_cat` [ RunTime:0.000845s ]
SELECT * FROM `db_cat` WHERE `catid` = 197 LIMIT 1 [ RunTime:0.000653s ]
SHOW FULL COLUMNS FROM `db_cat_data` [ RunTime:0.000784s ]
SELECT * FROM `db_cat_data` WHERE `catid` = 197 LIMIT 1 [ RunTime:0.000294s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 197 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000392s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 198 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000397s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 211 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000337s ]
SHOW FULL COLUMNS FROM `db_cms_product` [ RunTime:0.000898s ]
SELECT COUNT(*) AS think_count FROM `db_cms_product` WHERE `catid` IN (197,198,211) AND `is_inner` = 0 LIMIT 1 [ RunTime:0.000772s ]
SELECT COUNT(*) AS think_count FROM `db_cms_product` WHERE `catid` IN (197,198,211) AND `is_inner` = 0 LIMIT 1 [ RunTime:0.000776s ]
SELECT `id`,`catid`,`modelid`,`link`,`titleurl`,`pagetitle`,`keywords`,`description`,`pubid`,`sort`,`userid`,`username`,`addtime`,`editortime`,`is_good`,`is_top`,`views`,`goods`,`comments`,`compound_id`,`inventory`,`title`,`name`,`alias_name`,`smiles`,`cas`,`molecular_formula`,`molecular_weight`,`quantity`,`purity`,`spectrum`,`lablel`,`intro`,`thumb`,`newstime`,`type`,`specs`,`huohao`,`appearance`,`component`,`components` FROM `db_cms_product` WHERE `catid` IN (197,198,211) AND `is_inner` = 0 ORDER BY `sort` ASC,`is_top` DESC,`is_good` DESC,`newstime` DESC,`id` DESC LIMIT 0,20 [ RunTime:0.001146s ]
SELECT * FROM `db_cat` WHERE `catid` = 198 LIMIT 1 [ RunTime:0.000764s ]
SHOW FULL COLUMNS FROM `db_cms_specification` [ RunTime:0.000949s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 9763 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.009010s ]
SELECT * FROM `db_cat` WHERE `catid` = 198 LIMIT 1 [ RunTime:0.000632s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 9762 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.008921s ]
SELECT * FROM `db_cat` WHERE `catid` = 198 LIMIT 1 [ RunTime:0.000582s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 9364 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.008283s ]
SELECT * FROM `db_cat` WHERE `catid` = 198 LIMIT 1 [ RunTime:0.000666s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 9363 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.008001s ]
SELECT * FROM `db_cat` WHERE `catid` = 198 LIMIT 1 [ RunTime:0.000704s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 9362 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.008098s ]
SELECT * FROM `db_cat` WHERE `catid` = 198 LIMIT 1 [ RunTime:0.000599s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 9361 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.007799s ]
SELECT * FROM `db_cat` WHERE `catid` = 198 LIMIT 1 [ RunTime:0.000588s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 9360 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.007771s ]
SELECT * FROM `db_cat` WHERE `catid` = 198 LIMIT 1 [ RunTime:0.000586s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 9359 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.007897s ]
SELECT * FROM `db_cat` WHERE `catid` = 211 LIMIT 1 [ RunTime:0.000621s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 8159 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.004223s ]
SELECT * FROM `db_cat` WHERE `catid` = 198 LIMIT 1 [ RunTime:0.000667s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 7404 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.002178s ]
SELECT * FROM `db_cat` WHERE `catid` = 198 LIMIT 1 [ RunTime:0.000478s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 7403 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001823s ]
SELECT * FROM `db_cat` WHERE `catid` = 198 LIMIT 1 [ RunTime:0.000615s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 7402 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001919s ]
SELECT * FROM `db_cat` WHERE `catid` = 198 LIMIT 1 [ RunTime:0.000651s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 7401 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001897s ]
SELECT * FROM `db_cat` WHERE `catid` = 198 LIMIT 1 [ RunTime:0.000561s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 7400 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001810s ]
SELECT * FROM `db_cat` WHERE `catid` = 198 LIMIT 1 [ RunTime:0.000656s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 7399 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001774s ]
SELECT * FROM `db_cat` WHERE `catid` = 198 LIMIT 1 [ RunTime:0.000643s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 7398 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001778s ]
SELECT * FROM `db_cat` WHERE `catid` = 198 LIMIT 1 [ RunTime:0.000741s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 7397 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001844s ]
SELECT * FROM `db_cat` WHERE `catid` = 198 LIMIT 1 [ RunTime:0.000400s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 7396 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001861s ]
SELECT * FROM `db_cat` WHERE `catid` = 198 LIMIT 1 [ RunTime:0.000397s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 7395 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001860s ]
SELECT * FROM `db_cat` WHERE `catid` = 198 LIMIT 1 [ RunTime:0.000409s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 7394 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.001818s ]
SELECT `id` FROM `db_cms_product` WHERE `catid` IN (197,198,211) AND `is_inner` = 0 [ RunTime:0.000864s ]
UPDATE `db_cat` SET `views` = `views` + 1 WHERE `catid` = 197 [ RunTime:0.004795s ]
SELECT * FROM `db_cat` WHERE `pid` = 74 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000668s ]
SELECT * FROM `db_cat` WHERE `pid` = 92 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000502s ]
SELECT * FROM `db_cat` WHERE `pid` = 195 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000518s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 97 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000487s ]
SHOW FULL COLUMNS FROM `db_cms_home` [ RunTime:0.000768s ]
SELECT * FROM `db_cms_home` WHERE `catid` = 97 ORDER BY `sort` ASC,`is_top` DESC,`is_good` DESC,`newstime` DESC LIMIT 1 [ RunTime:0.000543s ]
SELECT * FROM `db_cat` WHERE `pid` = 74 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000589s ]
SELECT * FROM `db_cat` WHERE `pid` = 75 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000540s ]
SELECT * FROM `db_cat` WHERE `pid` = 76 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000460s ]
SELECT * FROM `db_cat` WHERE `pid` = 79 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000506s ]
SELECT * FROM `db_cat` WHERE `pid` = 212 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000450s ]
SELECT * FROM `db_cat` WHERE `pid` = 214 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000494s ]
SELECT * FROM `db_cat` WHERE `pid` = 176 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000523s ]
SELECT * FROM `db_cat` WHERE `pid` = 177 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000827s ]
SELECT * FROM `db_cat` WHERE `pid` = 178 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000940s ]
SELECT * FROM `db_cat` WHERE `pid` = 179 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000560s ]
SELECT * FROM `db_cat` WHERE `pid` = 180 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000502s ]
SELECT * FROM `db_cat` WHERE `pid` = 197 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000475s ]
SELECT * FROM `db_cat` WHERE `pid` = 198 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000439s ]
SELECT * FROM `db_cat` WHERE `pid` = 211 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000452s ]
SELECT * FROM `db_cat` WHERE `pid` = 78 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000564s ]
SELECT * FROM `db_cat` WHERE `pid` = 80 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000600s ]
SELECT * FROM `db_cat` WHERE `pid` = 81 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000480s ]
SELECT * FROM `db_cat` WHERE `pid` = 82 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000485s ]
SELECT * FROM `db_cat` WHERE `pid` = 83 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000528s ]
SELECT * FROM `db_cat` WHERE `pid` = 128 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000988s ]
SELECT * FROM `db_cat` WHERE `pid` = 222 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000583s ]
SELECT * FROM `db_cat` WHERE `pid` = 84 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000589s ]
SELECT * FROM `db_cat` WHERE `pid` = 193 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000685s ]
SELECT * FROM `db_cat` WHERE `pid` = 207 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000449s ]
SELECT * FROM `db_cat` WHERE `pid` = 92 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000465s ]
SELECT * FROM `db_cat` WHERE `pid` = 195 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000512s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 95 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000632s ]
SHOW FULL COLUMNS FROM `db_cms_contact` [ RunTime:0.000789s ]
SELECT * FROM `db_cms_contact` WHERE `catid` = 95 ORDER BY `sort` ASC,`is_top` DESC,`is_good` DESC,`newstime` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT * FROM `db_cat` WHERE `pid` = 74 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000587s ]
SELECT * FROM `db_cat` WHERE `pid` = 197 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000862s ]
SELECT * FROM `db_cat` WHERE `pid` = 198 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000631s ]
SELECT * FROM `db_cat` WHERE `pid` = 211 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000719s ]
SELECT * FROM `db_cat` WHERE `pid` = 195 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000806s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 95 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000604s ]
SELECT * FROM `db_cms_contact` WHERE `catid` = 95 ORDER BY `sort` ASC,`is_top` DESC,`is_good` DESC,`newstime` DESC [ RunTime:0.000595s ]
SHOW FULL COLUMNS FROM `db_link` [ RunTime:0.000870s ]
SELECT * FROM `db_link` WHERE `catid` = 12 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000491s ]