set session sql_mode='NO_ENGINE_SUBSTITUTION' [ RunTime:0.000436s ]
SHOW FULL COLUMNS FROM `tp_1_industrial` [ RunTime:0.001361s ]
SELECT * FROM `tp_1_industrial` WHERE `id` = 30 LIMIT 1 [ RunTime:0.001660s ]
SHOW FULL COLUMNS FROM `tp_1_industrial_data_0` [ RunTime:0.000729s ]
SELECT * FROM `tp_1_industrial_data_0` WHERE `id` = 30 LIMIT 1 [ RunTime:0.001305s ]
SELECT * FROM `tp_1_industrial` WHERE `catid` = 29 AND ( id<30 ) ORDER BY id desc LIMIT 1 [ RunTime:0.000955s ]
SELECT * FROM `tp_1_industrial` WHERE `catid` = 29 AND ( id>30 ) ORDER BY id asc LIMIT 1 [ RunTime:0.002022s ]
show COLUMNS FROM tp_1_industrialbuilding_category_data [ RunTime:0.001136s ]
SELECT `tp_1_industrialbuilding`.* FROM `tp_1_industrialbuilding` LEFT JOIN tp_1_industrialbuilding_category_data ON `tp_1_industrialbuilding_category_data`.`id`=`tp_1_industrialbuilding`.`id` WHERE `tp_1_industrialbuilding`.`id` IN (1008) ORDER BY `tp_1_industrialbuilding`.`updatetime` DESC [ RunTime:0.001020s ]
show COLUMNS FROM tp_1_industrialbuilding_category_data [ RunTime:0.001217s ]
SELECT `tp_1_industrialbuilding`.* FROM `tp_1_industrialbuilding` LEFT JOIN tp_1_industrialbuilding_category_data ON `tp_1_industrialbuilding_category_data`.`id`=`tp_1_industrialbuilding`.`id` WHERE `tp_1_industrialbuilding`.`id` IN (1008) ORDER BY `tp_1_industrialbuilding`.`updatetime` DESC [ RunTime:0.001096s ]
show COLUMNS FROM tp_1_industrialbuilding_category_data [ RunTime:0.001011s ]
SELECT `tp_1_industrialbuilding`.* FROM `tp_1_industrialbuilding` LEFT JOIN tp_1_industrialbuilding_category_data ON `tp_1_industrialbuilding_category_data`.`id`=`tp_1_industrialbuilding`.`id` WHERE `tp_1_industrialbuilding`.`id` IN (1008) ORDER BY `tp_1_industrialbuilding`.`updatetime` DESC [ RunTime:0.000693s ]
show COLUMNS FROM tp_1_industrialbuilding_category_data [ RunTime:0.000872s ]
SELECT `tp_1_industrialbuilding`.* FROM `tp_1_industrialbuilding` LEFT JOIN tp_1_industrialbuilding_category_data ON `tp_1_industrialbuilding_category_data`.`id`=`tp_1_industrialbuilding`.`id` WHERE `tp_1_industrialbuilding`.`id` IN (1008) ORDER BY `tp_1_industrialbuilding`.`updatetime` DESC [ RunTime:0.000699s ]
show COLUMNS FROM tp_1_industrialbuilding_category_data [ RunTime:0.000918s ]
SELECT `tp_1_industrialbuilding`.* FROM `tp_1_industrialbuilding` LEFT JOIN tp_1_industrialbuilding_category_data ON `tp_1_industrialbuilding_category_data`.`id`=`tp_1_industrialbuilding`.`id` WHERE `tp_1_industrialbuilding`.`id` IN (1008) ORDER BY `tp_1_industrialbuilding`.`updatetime` DESC [ RunTime:0.000898s ]
show COLUMNS FROM tp_1_industrialbuilding_category_data [ RunTime:0.000904s ]
SELECT `tp_1_industrialbuilding`.* FROM `tp_1_industrialbuilding` LEFT JOIN tp_1_industrialbuilding_category_data ON `tp_1_industrialbuilding_category_data`.`id`=`tp_1_industrialbuilding`.`id` WHERE `tp_1_industrialbuilding`.`id` IN (1008) ORDER BY `tp_1_industrialbuilding`.`updatetime` DESC [ RunTime:0.000722s ]
show COLUMNS FROM tp_1_industrialbuilding_category_data [ RunTime:0.001075s ]
SELECT `tp_1_industrialbuilding`.* FROM `tp_1_industrialbuilding` LEFT JOIN tp_1_industrialbuilding_category_data ON `tp_1_industrialbuilding_category_data`.`id`=`tp_1_industrialbuilding`.`id` WHERE `tp_1_industrialbuilding`.`id` IN (1008) ORDER BY `tp_1_industrialbuilding`.`updatetime` DESC [ RunTime:0.000812s ]
show COLUMNS FROM tp_1_industrialbuilding_category_data [ RunTime:0.000995s ]
SELECT `tp_1_industrialbuilding`.* FROM `tp_1_industrialbuilding` LEFT JOIN tp_1_industrialbuilding_category_data ON `tp_1_industrialbuilding_category_data`.`id`=`tp_1_industrialbuilding`.`id` WHERE `tp_1_industrialbuilding`.`id` IN (1008) ORDER BY `tp_1_industrialbuilding`.`updatetime` DESC [ RunTime:0.000711s ]
SELECT * FROM `tp_1_office` WHERE ( FIND_IN_SET (1008, `tp_1_office`.`relation_building`)) AND `tp_1_office`.`id` NOT IN (30) ORDER BY `tp_1_office`.`updatetime` DESC [ RunTime:0.003421s ]
show COLUMNS FROM tp_1_industrialbuilding_category_data [ RunTime:0.000731s ]
SELECT `tp_1_industrialbuilding`.* FROM `tp_1_industrialbuilding` LEFT JOIN tp_1_industrialbuilding_category_data ON `tp_1_industrialbuilding_category_data`.`id`=`tp_1_industrialbuilding`.`id` WHERE `tp_1_industrialbuilding`.`id` IN (1008) ORDER BY `tp_1_industrialbuilding`.`updatetime` DESC [ RunTime:0.000685s ]
show COLUMNS FROM tp_1_industrial_category_data [ RunTime:0.000821s ]
SELECT `tp_1_industrial`.* FROM `tp_1_industrial` LEFT JOIN tp_1_industrial_category_data ON `tp_1_industrial_category_data`.`id`=`tp_1_industrial`.`id` WHERE `tp_1_industrial`.`id` IN (82,137,159,267,269,276,277,433,486) ORDER BY `tp_1_industrial`.`updatetime` DESC [ RunTime:0.000730s ]
