set session sql_mode='NO_ENGINE_SUBSTITUTION' [ RunTime:0.001231s ]
SHOW FULL COLUMNS FROM `tp_1_office` [ RunTime:0.002200s ]
SELECT * FROM `tp_1_office` WHERE `id` = 344 LIMIT 1 [ RunTime:0.000574s ]
SHOW FULL COLUMNS FROM `tp_1_office_data_0` [ RunTime:0.000506s ]
SELECT * FROM `tp_1_office_data_0` WHERE `id` = 344 LIMIT 1 [ RunTime:0.000355s ]
SELECT * FROM `tp_1_office` WHERE `catid` = 4 AND ( id<344 ) ORDER BY id desc LIMIT 1 [ RunTime:0.001005s ]
SELECT * FROM `tp_1_office` WHERE `catid` = 4 AND ( id>344 ) ORDER BY id asc LIMIT 1 [ RunTime:0.000746s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.000899s ]
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 (108) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.000896s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.001009s ]
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 (108) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.000692s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.000790s ]
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 (108) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.000921s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.001136s ]
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 (108) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.000937s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.001042s ]
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 (108) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.001151s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.000686s ]
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 (108) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.000697s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.007268s ]
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 (108) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.000760s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.001399s ]
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 (108) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.001538s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.000880s ]
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 (108) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.001045s ]
SELECT * FROM `tp_1_office` WHERE ( FIND_IN_SET (108, `tp_1_office`.`relation_building`)) AND `tp_1_office`.`id` NOT IN (344) ORDER BY `tp_1_office`.`updatetime` DESC [ RunTime:0.005007s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.000958s ]
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 (108) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.001035s ]