SHOW FULL COLUMNS FROM `db_cat` [ RunTime:0.001009s ]
SELECT * FROM `db_cat` WHERE `catid` = 80 LIMIT 1 [ RunTime:0.000762s ]
SHOW FULL COLUMNS FROM `db_cat_data` [ RunTime:0.000926s ]
SELECT * FROM `db_cat_data` WHERE `catid` = 80 LIMIT 1 [ RunTime:0.000574s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 80 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000896s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 226 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000742s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 287 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000659s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 286 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000665s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 285 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000633s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 265 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000681s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 264 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000623s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 235 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000653s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 234 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000619s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 233 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000620s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 232 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000571s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 231 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000632s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 230 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000609s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 229 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000644s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 228 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000681s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 227 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000671s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 85 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000508s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 225 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000447s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 224 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000396s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 223 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000531s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 101 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000328s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 100 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000412s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 99 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000388s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 98 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000390s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 96 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000434s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 91 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000411s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 90 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000448s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 89 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000510s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 88 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000465s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 87 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000481s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 86 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000546s ]
SHOW FULL COLUMNS FROM `db_cms_product` [ RunTime:0.000881s ]
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.001912s ]
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.001821s ]
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 0,20 [ RunTime:0.003214s ]
SELECT * FROM `db_cat` WHERE `catid` = 98 LIMIT 1 [ RunTime:0.000651s ]
SHOW FULL COLUMNS FROM `db_cms_specification` [ RunTime:0.000935s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 9738 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.011805s ]
SELECT * FROM `db_cat` WHERE `catid` = 86 LIMIT 1 [ RunTime:0.000648s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 8937 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.009574s ]
SELECT * FROM `db_cat` WHERE `catid` = 91 LIMIT 1 [ RunTime:0.000578s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 8292 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.005728s ]
SELECT * FROM `db_cat` WHERE `catid` = 100 LIMIT 1 [ RunTime:0.000640s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 11557 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.012451s ]
SELECT * FROM `db_cat` WHERE `catid` = 98 LIMIT 1 [ RunTime:0.000613s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 11554 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.011675s ]
SELECT * FROM `db_cat` WHERE `catid` = 98 LIMIT 1 [ RunTime:0.000626s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 11553 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.011773s ]
SELECT * FROM `db_cat` WHERE `catid` = 98 LIMIT 1 [ RunTime:0.000745s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 11552 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.011655s ]
SELECT * FROM `db_cat` WHERE `catid` = 230 LIMIT 1 [ RunTime:0.000511s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 11551 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.011846s ]
SELECT * FROM `db_cat` WHERE `catid` = 225 LIMIT 1 [ RunTime:0.000581s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 11550 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.015661s ]
SELECT * FROM `db_cat` WHERE `catid` = 225 LIMIT 1 [ RunTime:0.000628s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 11549 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.015476s ]
SELECT * FROM `db_cat` WHERE `catid` = 225 LIMIT 1 [ RunTime:0.000648s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 11548 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.014854s ]
SELECT * FROM `db_cat` WHERE `catid` = 225 LIMIT 1 [ RunTime:0.000713s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 11547 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.011669s ]
SELECT * FROM `db_cat` WHERE `catid` = 225 LIMIT 1 [ RunTime:0.000660s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 11546 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.011530s ]
SELECT * FROM `db_cat` WHERE `catid` = 224 LIMIT 1 [ RunTime:0.000691s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 11545 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.011620s ]
SELECT * FROM `db_cat` WHERE `catid` = 224 LIMIT 1 [ RunTime:0.000818s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 11544 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.011741s ]
SELECT * FROM `db_cat` WHERE `catid` = 85 LIMIT 1 [ RunTime:0.000526s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 11543 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.011198s ]
SELECT * FROM `db_cat` WHERE `catid` = 225 LIMIT 1 [ RunTime:0.000509s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 11541 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.011207s ]
SELECT * FROM `db_cat` WHERE `catid` = 85 LIMIT 1 [ RunTime:0.000406s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 11486 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.011055s ]
SELECT * FROM `db_cat` WHERE `catid` = 88 LIMIT 1 [ RunTime:0.000497s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 11484 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.011225s ]
SELECT * FROM `db_cat` WHERE `catid` = 228 LIMIT 1 [ RunTime:0.000578s ]
SELECT * FROM `db_cms_specification` WHERE `product_id` = 11482 ORDER BY `id` ASC LIMIT 1 [ RunTime:0.011266s ]
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.002651s ]
UPDATE `db_cat` SET `views` = `views` + 1 WHERE `catid` = 80 [ RunTime:0.004697s ]
SELECT * FROM `db_cat` WHERE `pid` = 74 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000955s ]
SELECT * FROM `db_cat` WHERE `pid` = 92 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000962s ]
SELECT * FROM `db_cat` WHERE `pid` = 195 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000908s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 97 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000781s ]
SHOW FULL COLUMNS FROM `db_cms_home` [ RunTime:0.001020s ]
SELECT * FROM `db_cms_home` WHERE `catid` = 97 ORDER BY `sort` ASC,`is_top` DESC,`is_good` DESC,`newstime` DESC LIMIT 1 [ RunTime:0.000825s ]
SELECT * FROM `db_cat` WHERE `pid` = 74 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000972s ]
SELECT * FROM `db_cat` WHERE `pid` = 75 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.001013s ]
SELECT * FROM `db_cat` WHERE `pid` = 76 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000871s ]
SELECT * FROM `db_cat` WHERE `pid` = 79 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000870s ]
SELECT * FROM `db_cat` WHERE `pid` = 212 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000613s ]
SELECT * FROM `db_cat` WHERE `pid` = 214 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000500s ]
SELECT * FROM `db_cat` WHERE `pid` = 176 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000574s ]
SELECT * FROM `db_cat` WHERE `pid` = 177 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000595s ]
SELECT * FROM `db_cat` WHERE `pid` = 178 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000504s ]
SELECT * FROM `db_cat` WHERE `pid` = 179 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000452s ]
SELECT * FROM `db_cat` WHERE `pid` = 180 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000540s ]
SELECT * FROM `db_cat` WHERE `pid` = 197 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000558s ]
SELECT * FROM `db_cat` WHERE `pid` = 198 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000534s ]
SELECT * FROM `db_cat` WHERE `pid` = 211 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000487s ]
SELECT * FROM `db_cat` WHERE `pid` = 78 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000515s ]
SELECT * FROM `db_cat` WHERE `pid` = 80 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000725s ]
SELECT * FROM `db_cat` WHERE `pid` = 81 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000951s ]
SELECT * FROM `db_cat` WHERE `pid` = 82 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000658s ]
SELECT * FROM `db_cat` WHERE `pid` = 83 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000603s ]
SELECT * FROM `db_cat` WHERE `pid` = 128 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.001119s ]
SELECT * FROM `db_cat` WHERE `pid` = 222 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000705s ]
SELECT * FROM `db_cat` WHERE `pid` = 84 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000667s ]
SELECT * FROM `db_cat` WHERE `pid` = 193 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000599s ]
SELECT * FROM `db_cat` WHERE `pid` = 207 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000559s ]
SELECT * FROM `db_cat` WHERE `pid` = 92 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000743s ]
SELECT * FROM `db_cat` WHERE `pid` = 195 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000607s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 95 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000430s ]
SHOW FULL COLUMNS FROM `db_cms_contact` [ RunTime:0.000753s ]
SELECT * FROM `db_cms_contact` WHERE `catid` = 95 ORDER BY `sort` ASC,`is_top` DESC,`is_good` DESC,`newstime` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT * FROM `db_cat` WHERE `pid` = 195 AND `status` = 1 ORDER BY `sort` ASC,`catid` ASC [ RunTime:0.000703s ]
SELECT `catid`,`modelid` FROM `db_cat` WHERE `pid` = 95 AND `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001361s ]
SELECT * FROM `db_cms_contact` WHERE `catid` = 95 ORDER BY `sort` ASC,`is_top` DESC,`is_good` DESC,`newstime` DESC [ RunTime:0.000516s ]
SHOW FULL COLUMNS FROM `db_link` [ RunTime:0.000649s ]
SELECT * FROM `db_link` WHERE `catid` = 12 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000493s ]