set session sql_mode='NO_ENGINE_SUBSTITUTION' [ RunTime:0.003743s ]
SHOW FULL COLUMNS FROM `tp_1_office` [ RunTime:0.002799s ]
SELECT * FROM `tp_1_office` WHERE `id` = 196 LIMIT 1 [ RunTime:0.001508s ]
SHOW FULL COLUMNS FROM `tp_1_office_data_0` [ RunTime:0.003631s ]
SELECT * FROM `tp_1_office_data_0` WHERE `id` = 196 LIMIT 1 [ RunTime:0.004107s ]
SELECT * FROM `tp_1_office` WHERE `catid` = 4 AND ( id<196 ) ORDER BY id desc LIMIT 1 [ RunTime:0.009856s ]
SELECT * FROM `tp_1_office` WHERE `catid` = 4 AND ( id>196 ) ORDER BY id asc LIMIT 1 [ RunTime:0.001322s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.003057s ]
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 (74) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.004481s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.002634s ]
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 (74) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.001369s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.003712s ]
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 (74) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.000901s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.002118s ]
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 (74) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.002487s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.003451s ]
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 (74) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.003554s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.003029s ]
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.037082s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.004226s ]
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 (74) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.003293s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.001123s ]
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 (74) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.001489s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.002284s ]
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 (74) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.000915s ]
SELECT * FROM `tp_1_office` WHERE ( FIND_IN_SET (74, `tp_1_office`.`relation_building`)) AND `tp_1_office`.`id` NOT IN (196) ORDER BY `tp_1_office`.`updatetime` DESC [ RunTime:0.006589s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.018997s ]
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 (74) ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.002487s ]
