SHOW FULL COLUMNS FROM `db_city` [ RunTime:0.000948s ]
SHOW FULL COLUMNS FROM `db_nav_info` [ RunTime:0.000726s ]
SELECT * FROM `db_nav_info` WHERE `nav_id` = 1 AND ( `status` = 1 ) ORDER BY `order` ASC [ RunTime:0.000274s ]
SHOW FULL COLUMNS FROM `db_blogroll` [ RunTime:0.000747s ]
SELECT * FROM `db_blogroll` WHERE `status` = 3 AND `areaid` = 118 [ RunTime:0.000265s ]
SHOW FULL COLUMNS FROM `db_setting` [ RunTime:0.000624s ]
SELECT `name`,`info` FROM `db_setting` [ RunTime:0.000182s ]
SHOW FULL COLUMNS FROM `db_seo` [ RunTime:0.000680s ]
SELECT * FROM `db_seo` WHERE `url` = '/case/show' LIMIT 1 [ RunTime:0.000218s ]
SHOW FULL COLUMNS FROM `db_photo` [ RunTime:0.000923s ]
SELECT * FROM `db_photo` WHERE `itemid` = 1897431 AND `status` = 3 AND `itemid` = 1897431 LIMIT 1 [ RunTime:0.000503s ]
SHOW FULL COLUMNS FROM `db_photo_data` [ RunTime:0.000627s ]
SELECT `content` FROM `db_photo_data` WHERE `itemid` = 1897431 LIMIT 1 [ RunTime:0.000209s ]
SHOW FULL COLUMNS FROM `db_member` [ RunTime:0.000930s ]
SELECT `areaid` FROM `db_member` WHERE `userid` = 51405 LIMIT 1 [ RunTime:0.000206s ]
SELECT * FROM `db_city` WHERE `areaid` = 118 AND `is_open` = 1 LIMIT 1 [ RunTime:0.000251s ]
SHOW FULL COLUMNS FROM `db_company` [ RunTime:0.000929s ]
SELECT `c`.`company_jc` FROM `db_company` `c` LEFT JOIN `db_company_data` `cd` ON `cd`.`userid`=`c`.`userid` WHERE `c`.`userid` = 51400 LIMIT 1 [ RunTime:0.000243s ]
SHOW FULL COLUMNS FROM `db_photo_item` [ RunTime:0.000929s ]
SELECT `itemid`,`item`,`title`,`fileurl`,`thumb`,`thumbnail` FROM `db_photo_item` WHERE `item` = 1897431 AND `status` > 0 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 50 [ RunTime:0.000561s ]
SELECT `userid`,`company`,`company_jc`,`thumb` FROM `db_company` WHERE `areaid` = 118 AND `groupid` = 1 AND `thumb` <> '' AND `status` = 3 ORDER BY `vip` DESC LIMIT 4 [ RunTime:0.000241s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51244 [ RunTime:0.004992s ]
SHOW FULL COLUMNS FROM `db_comment` [ RunTime:0.000782s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51244 [ RunTime:0.000205s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51263 [ RunTime:0.004832s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51263 [ RunTime:0.001338s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51275 [ RunTime:0.004836s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51275 [ RunTime:0.000207s ]
SELECT COUNT(*) AS think_count FROM `db_photo` WHERE `mid` = 51293 [ RunTime:0.004814s ]
SELECT COUNT(*) AS think_count FROM `db_comment` WHERE `userid` = 51293 [ RunTime:0.000492s ]
UPDATE `db_photo` SET `hits` = 293 WHERE `itemid` = 1897431 [ RunTime:0.001780s ]
SELECT * FROM `db_photo` WHERE `itemid` < 1897431 AND `status` = 3 ORDER BY `itemid` DESC LIMIT 1 [ RunTime:0.000537s ]
SELECT * FROM `db_photo` WHERE `itemid` > 1897431 AND `status` = 3 ORDER BY `itemid` ASC LIMIT 1 [ RunTime:0.000488s ]
SHOW FULL COLUMNS FROM `db_area` [ RunTime:0.000729s ]
SELECT areaid as code,areaname as name,parentid as province FROM `db_area` WHERE `parentid` = 0 ORDER BY `areaid` [ RunTime:0.000218s ]
SHOW FULL COLUMNS FROM `db_category` [ RunTime:0.000777s ]
SELECT * FROM `db_category` WHERE `catid` = 1518 LIMIT 1 [ RunTime:0.000257s ]
SELECT * FROM `db_category` WHERE `catid` = 1538 LIMIT 1 [ RunTime:0.000242s ]
SELECT * FROM `db_category` WHERE `catid` = 1562 LIMIT 1 [ RunTime:0.000242s ]
SELECT * FROM `db_category` WHERE `catid` = 1572 LIMIT 1 [ RunTime:0.000235s ]
