set session sql_mode='NO_ENGINE_SUBSTITUTION' [ RunTime:0.010249s ]
SHOW FULL COLUMNS FROM `tp_1_office` [ RunTime:0.011384s ]
SELECT * FROM `tp_1_office` WHERE `id` = 1184 LIMIT 1 [ RunTime:0.000687s ]
SHOW FULL COLUMNS FROM `tp_1_office_data_0` [ RunTime:0.000578s ]
SELECT * FROM `tp_1_office_data_0` WHERE `id` = 1184 LIMIT 1 [ RunTime:0.000365s ]
SELECT * FROM `tp_1_office` WHERE `catid` = 4 AND ( id<1184 ) ORDER BY id desc LIMIT 1 [ RunTime:0.013573s ]
SELECT * FROM `tp_1_office` WHERE `catid` = 4 AND ( id>1184 ) ORDER BY id asc LIMIT 1 [ RunTime:0.000709s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.009189s ]
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 (103) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.004184s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.005019s ]
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 (103) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.002594s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.003602s ]
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 (103) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.000693s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.001402s ]
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 (103) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.004083s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.015502s ]
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 (103) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.000808s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.000738s ]
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.028192s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.004731s ]
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 (103) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.002949s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.000690s ]
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 (103) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.000620s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.000624s ]
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 (103) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.000833s ]
SELECT * FROM `tp_1_office` WHERE ( FIND_IN_SET (103, `tp_1_office`.`relation_building`)) AND `tp_1_office`.`id` NOT IN (1184) ORDER BY `tp_1_office`.`updatetime` DESC [ RunTime:0.003447s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.000954s ]
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 (103) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.000825s ]