set session sql_mode='NO_ENGINE_SUBSTITUTION' [ RunTime:0.000225s ]
SHOW FULL COLUMNS FROM `tp_1_office` [ RunTime:0.000964s ]
SELECT * FROM `tp_1_office` WHERE `id` = 1162 LIMIT 1 [ RunTime:0.000709s ]
SHOW FULL COLUMNS FROM `tp_1_office_data_0` [ RunTime:0.000689s ]
SELECT * FROM `tp_1_office_data_0` WHERE `id` = 1162 LIMIT 1 [ RunTime:0.000359s ]
SELECT * FROM `tp_1_office` WHERE `catid` = 4 AND ( id<1162 ) ORDER BY id desc LIMIT 1 [ RunTime:0.000763s ]
SELECT * FROM `tp_1_office` WHERE `catid` = 4 AND ( id>1162 ) ORDER BY id asc LIMIT 1 [ RunTime:0.000599s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.001246s ]
SELECT `tp_1_officebuilding`.* FROM `tp_1_officebuilding` LEFT JOIN tp_1_officebuilding_category_data ON `tp_1_officebuilding_category_data`.`id`=`tp_1_officebuilding`.`id` WHERE `tp_1_officebuilding`.`id` IN (87) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.000777s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.000714s ]
SELECT `tp_1_officebuilding`.* FROM `tp_1_officebuilding` LEFT JOIN tp_1_officebuilding_category_data ON `tp_1_officebuilding_category_data`.`id`=`tp_1_officebuilding`.`id` WHERE `tp_1_officebuilding`.`id` IN (87) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.000649s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.000604s ]
SELECT `tp_1_officebuilding`.* FROM `tp_1_officebuilding` LEFT JOIN tp_1_officebuilding_category_data ON `tp_1_officebuilding_category_data`.`id`=`tp_1_officebuilding`.`id` WHERE `tp_1_officebuilding`.`id` IN (87) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.000758s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.000697s ]
SELECT `tp_1_officebuilding`.* FROM `tp_1_officebuilding` LEFT JOIN tp_1_officebuilding_category_data ON `tp_1_officebuilding_category_data`.`id`=`tp_1_officebuilding`.`id` WHERE `tp_1_officebuilding`.`id` IN (87) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.000703s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.000589s ]
SELECT `tp_1_officebuilding`.* FROM `tp_1_officebuilding` LEFT JOIN tp_1_officebuilding_category_data ON `tp_1_officebuilding_category_data`.`id`=`tp_1_officebuilding`.`id` WHERE `tp_1_officebuilding`.`id` IN (87) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.000579s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.000568s ]
SELECT `tp_1_officebuilding`.* FROM `tp_1_officebuilding` LEFT JOIN tp_1_officebuilding_category_data ON `tp_1_officebuilding_category_data`.`id`=`tp_1_officebuilding`.`id` ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.026577s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.006638s ]
SELECT `tp_1_officebuilding`.* FROM `tp_1_officebuilding` LEFT JOIN tp_1_officebuilding_category_data ON `tp_1_officebuilding_category_data`.`id`=`tp_1_officebuilding`.`id` WHERE `tp_1_officebuilding`.`id` IN (87) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.000833s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.000771s ]
SELECT `tp_1_officebuilding`.* FROM `tp_1_officebuilding` LEFT JOIN tp_1_officebuilding_category_data ON `tp_1_officebuilding_category_data`.`id`=`tp_1_officebuilding`.`id` WHERE `tp_1_officebuilding`.`id` IN (87) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.000635s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.004288s ]
SELECT `tp_1_officebuilding`.* FROM `tp_1_officebuilding` LEFT JOIN tp_1_officebuilding_category_data ON `tp_1_officebuilding_category_data`.`id`=`tp_1_officebuilding`.`id` WHERE `tp_1_officebuilding`.`id` IN (87) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.001132s ]
SELECT * FROM `tp_1_office` WHERE ( FIND_IN_SET (87, `tp_1_office`.`relation_building`)) AND `tp_1_office`.`id` NOT IN (1162) ORDER BY `tp_1_office`.`updatetime` DESC [ RunTime:0.007827s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.001798s ]
SELECT `tp_1_officebuilding`.* FROM `tp_1_officebuilding` LEFT JOIN tp_1_officebuilding_category_data ON `tp_1_officebuilding_category_data`.`id`=`tp_1_officebuilding`.`id` WHERE `tp_1_officebuilding`.`id` IN (87) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.001192s ]
