SHOW FULL COLUMNS FROM `db_cat` [ RunTime:0.001037s ]
SELECT * FROM `db_cat` WHERE `catid` = 80 LIMIT 1 [ RunTime:0.000949s ]
SHOW FULL COLUMNS FROM `db_cat_data` [ RunTime:0.000725s ]
SELECT * FROM `db_cat_data` WHERE `catid` = 80 LIMIT 1 [ RunTime:0.000354s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 80 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000456s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 226 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000413s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 287 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000295s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 286 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000330s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 285 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000331s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 265 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000285s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 264 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000292s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 235 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000292s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 234 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000277s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 233 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000284s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 232 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000313s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 231 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000377s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 230 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000622s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 229 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000661s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 228 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000561s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 227 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000609s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 85 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000674s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 225 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000368s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 224 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000518s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 223 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000556s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 101 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000310s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 100 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000309s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 99 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000237s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 98 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000286s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 96 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000242s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 91 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000379s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 90 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000341s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 89 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000244s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 88 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000266s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 87 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000286s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 86 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000281s ]
SHOW FULL COLUMNS FROM `db_cms_product` [ RunTime:0.000714s ]
SELECT COUNT(*) AS think_count FROM `db_cms_product` WHERE `catid` IN (80,226,287,286,285,265,264,235,234,233,232,231,230,229,228,227,85,225,224,223,101,100,99,98,96,91,90,89,88,87,86) AND `is_inner` = 0 LIMIT 1 [ RunTime:0.001735s ]
SELECT COUNT(*) AS think_count FROM `db_cms_product` WHERE `catid` IN (80,226,287,286,285,265,264,235,234,233,232,231,230,229,228,227,85,225,224,223,101,100,99,98,96,91,90,89,88,87,86) AND `is_inner` = 0 LIMIT 1 [ RunTime:0.001841s ]
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 (80,226,287,286,285,265,264,235,234,233,232,231,230,229,228,227,85,225,224,223,101,100,99,98,96,91,90,89,88,87,86) AND `is_inner` = 0 ORDER BY `sort` ASC,`is_top` DESC,`is_good` DESC,`newstime` DESC,`id` DESC LIMIT 140,20 [ RunTime:0.003089s ]
SELECT * FROM `db_cat` WHERE `catid` = 85 LIMIT 1 [ RunTime:0.000575s ]
SHOW FULL COLUMNS FROM `db_cms_specification` [ RunTime:0.000707s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 10227 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.009553s ]
SELECT * FROM `db_cat` WHERE `catid` = 85 LIMIT 1 [ RunTime:0.000497s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 10226 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.009429s ]
SELECT * FROM `db_cat` WHERE `catid` = 85 LIMIT 1 [ RunTime:0.000516s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 10225 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.009279s ]
SELECT * FROM `db_cat` WHERE `catid` = 85 LIMIT 1 [ RunTime:0.000451s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 10224 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.009339s ]
SELECT * FROM `db_cat` WHERE `catid` = 85 LIMIT 1 [ RunTime:0.000448s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 10223 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.009306s ]
SELECT * FROM `db_cat` WHERE `catid` = 85 LIMIT 1 [ RunTime:0.000409s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 10222 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.009249s ]
SELECT * FROM `db_cat` WHERE `catid` = 85 LIMIT 1 [ RunTime:0.000453s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 10221 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.009392s ]
SELECT * FROM `db_cat` WHERE `catid` = 85 LIMIT 1 [ RunTime:0.000415s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 10220 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.009442s ]
SELECT * FROM `db_cat` WHERE `catid` = 85 LIMIT 1 [ RunTime:0.000558s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 10219 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.009550s ]
SELECT * FROM `db_cat` WHERE `catid` = 85 LIMIT 1 [ RunTime:0.000775s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 10218 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.009251s ]
SELECT * FROM `db_cat` WHERE `catid` = 85 LIMIT 1 [ RunTime:0.000551s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 10217 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.009521s ]
SELECT * FROM `db_cat` WHERE `catid` = 85 LIMIT 1 [ RunTime:0.000539s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 10216 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.009209s ]
SELECT * FROM `db_cat` WHERE `catid` = 85 LIMIT 1 [ RunTime:0.000593s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 10215 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.009431s ]
SELECT * FROM `db_cat` WHERE `catid` = 85 LIMIT 1 [ RunTime:0.000592s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 10214 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.009226s ]
SELECT * FROM `db_cat` WHERE `catid` = 85 LIMIT 1 [ RunTime:0.000480s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 10213 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.009160s ]
SELECT * FROM `db_cat` WHERE `catid` = 85 LIMIT 1 [ RunTime:0.000431s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 10212 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.009219s ]
SELECT * FROM `db_cat` WHERE `catid` = 85 LIMIT 1 [ RunTime:0.000438s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 10211 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.009397s ]
SELECT * FROM `db_cat` WHERE `catid` = 91 LIMIT 1 [ RunTime:0.000460s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 9743 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.008895s ]
SELECT * FROM `db_cat` WHERE `catid` = 90 LIMIT 1 [ RunTime:0.000445s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 9742 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.008621s ]
SELECT * FROM `db_cat` WHERE `catid` = 287 LIMIT 1 [ RunTime:0.000645s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 10196 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.009920s ]
SELECT `id` FROM `db_cms_product` WHERE `catid` IN (80,226,287,286,285,265,264,235,234,233,232,231,230,229,228,227,85,225,224,223,101,100,99,98,96,91,90,89,88,87,86) AND `is_inner` = 0 [ RunTime:0.002389s ]
UPDATE `db_cat` SET `views` = `views` + 1 WHERE `catid` = 80 [ RunTime:0.005021s ]
SELECT * FROM `db_cat` WHERE `pid` = 74 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000699s ]
SELECT * FROM `db_cat` WHERE `pid` = 92 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000572s ]
SELECT * FROM `db_cat` WHERE `pid` = 195 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000578s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 97 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000577s ]
SHOW FULL COLUMNS FROM `db_cms_home` [ RunTime:0.000759s ]
SELECT * FROM `db_cms_home` WHERE `catid` = 97 ORDER BY `sort` ASC,`is_top` DESC,`is_good` DESC,`newstime` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT * FROM `db_cat` WHERE `pid` = 74 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000622s ]
SELECT * FROM `db_cat` WHERE `pid` = 75 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000556s ]
SELECT * FROM `db_cat` WHERE `pid` = 76 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000501s ]
SELECT * FROM `db_cat` WHERE `pid` = 79 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000404s ]
SELECT * FROM `db_cat` WHERE `pid` = 212 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000414s ]
SELECT * FROM `db_cat` WHERE `pid` = 214 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000436s ]
SELECT * FROM `db_cat` WHERE `pid` = 176 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000461s ]
SELECT * FROM `db_cat` WHERE `pid` = 177 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000454s ]
SELECT * FROM `db_cat` WHERE `pid` = 178 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000550s ]
SELECT * FROM `db_cat` WHERE `pid` = 179 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000629s ]
SELECT * FROM `db_cat` WHERE `pid` = 180 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000489s ]
SELECT * FROM `db_cat` WHERE `pid` = 197 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000577s ]
SELECT * FROM `db_cat` WHERE `pid` = 198 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000466s ]
SELECT * FROM `db_cat` WHERE `pid` = 211 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000579s ]
SELECT * FROM `db_cat` WHERE `pid` = 78 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000827s ]
SELECT * FROM `db_cat` WHERE `pid` = 80 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000874s ]
SELECT * FROM `db_cat` WHERE `pid` = 81 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000803s ]
SELECT * FROM `db_cat` WHERE `pid` = 82 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000736s ]
SELECT * FROM `db_cat` WHERE `pid` = 83 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000758s ]
SELECT * FROM `db_cat` WHERE `pid` = 128 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000979s ]
SELECT * FROM `db_cat` WHERE `pid` = 222 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.001178s ]
SELECT * FROM `db_cat` WHERE `pid` = 84 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.001090s ]
SELECT * FROM `db_cat` WHERE `pid` = 193 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000689s ]
SELECT * FROM `db_cat` WHERE `pid` = 207 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000619s ]
SELECT * FROM `db_cat` WHERE `pid` = 92 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000801s ]
SELECT * FROM `db_cat` WHERE `pid` = 195 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000707s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 95 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000556s ]
SHOW FULL COLUMNS FROM `db_cms_contact` [ RunTime:0.000910s ]
SELECT * FROM `db_cms_contact` WHERE `catid` = 95 ORDER BY `sort` ASC,`is_top` DESC,`is_good` DESC,`newstime` DESC LIMIT 1 [ RunTime:0.000596s ]
SELECT * FROM `db_cat` WHERE `pid` = 195 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000786s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 95 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000535s ]
SELECT * FROM `db_cms_contact` WHERE `catid` = 95 ORDER BY `sort` ASC,`is_top` DESC,`is_good` DESC,`newstime` DESC [ RunTime:0.000439s ]
SHOW FULL COLUMNS FROM `db_link` [ RunTime:0.000788s ]
SELECT * FROM `db_link` WHERE `catid` = 12 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000413s ]