set session sql_mode='NO_ENGINE_SUBSTITUTION' [ RunTime:0.000238s ]
SHOW FULL COLUMNS FROM `tp_1_office` [ RunTime:0.001118s ]
SELECT * FROM `tp_1_office` WHERE `id` = 1444 LIMIT 1 [ RunTime:0.000989s ]
SHOW FULL COLUMNS FROM `tp_1_office_data_0` [ RunTime:0.008811s ]
SELECT * FROM `tp_1_office_data_0` WHERE `id` = 1444 LIMIT 1 [ RunTime:0.002072s ]
SELECT * FROM `tp_1_office` WHERE `catid` = 6 AND `fstatus` = 1 AND ( id<1444 ) ORDER BY id desc LIMIT 1 [ RunTime:0.009372s ]
SELECT * FROM `tp_1_office` WHERE `catid` = 6 AND `fstatus` = 1 AND ( id>1444 ) ORDER BY id asc LIMIT 1 [ RunTime:0.001833s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.000571s ]
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 (140) AND `fstatus`=1 ORDER BY `tp_1_officebuilding`.`updatetime` DESC LIMIT 1 [ RunTime:0.000546s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.004888s ]
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 (140) AND `fstatus`=1 ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.000665s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.010569s ]
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 (140) AND `fstatus`=1 ORDER BY `tp_1_officebuilding`.`updatetime` DESC [ RunTime:0.000919s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.001067s ]
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 (140) AND `fstatus`=1 ORDER BY `tp_1_officebuilding`.`updatetime` DESC LIMIT 1 [ RunTime:0.000716s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.000786s ]
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 (140) AND `fstatus`=1 ORDER BY `tp_1_officebuilding`.`updatetime` DESC LIMIT 1 [ RunTime:0.000765s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.000613s ]
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 (140) AND `fstatus`=1 ORDER BY `tp_1_officebuilding`.`updatetime` DESC LIMIT 1 [ RunTime:0.000796s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.000785s ]
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 (140) AND `fstatus`=1 ORDER BY `tp_1_officebuilding`.`updatetime` DESC LIMIT 1 [ RunTime:0.000601s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.000570s ]
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 (140) AND `fstatus`=1 ORDER BY `tp_1_officebuilding`.`updatetime` DESC LIMIT 1 [ RunTime:0.000656s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.000615s ]
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 (140) AND `fstatus`=1 ORDER BY `tp_1_officebuilding`.`updatetime` DESC LIMIT 1 [ RunTime:0.000692s ]
SELECT * FROM `tp_1_office` WHERE ( FIND_IN_SET (140, `tp_1_office`.`relation_building`)) AND `tp_1_office`.`id` NOT IN (1444) AND `fstatus`=1 ORDER BY `tp_1_office`.`updatetime` DESC [ RunTime:0.005085s ]
show COLUMNS FROM tp_1_officebuilding_category_data [ RunTime:0.000625s ]
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 (140) AND `fstatus`=1 ORDER BY `tp_1_officebuilding`.`updatetime` DESC LIMIT 1 [ RunTime:0.000556s ]
