set session sql_mode='NO_ENGINE_SUBSTITUTION' [ RunTime:0.000590s ]
SHOW FULL COLUMNS FROM `tp_linkage_data_2` [ RunTime:0.002567s ]
SELECT `id`,`pid`,`name`,`cname`,`en_name`,`cn_name` FROM `tp_linkage_data_2` [ RunTime:0.003530s ]
SHOW FULL COLUMNS FROM `tp_site` [ RunTime:0.003593s ]
SELECT * FROM `tp_site` WHERE `disabled` = 0 [ RunTime:0.001984s ]
SHOW FULL COLUMNS FROM `tp_module` [ RunTime:0.002274s ]
SELECT * FROM `tp_module` WHERE 1 ORDER BY displayorder ASC,id ASC [ RunTime:0.001382s ]
SHOW FULL COLUMNS FROM `tp_field` [ RunTime:0.003527s ]
SELECT * FROM `tp_field` WHERE `disabled` = 0 AND `relatedid` = 1 AND `relatedname` = 'site' ORDER BY displayorder ASC,id ASC [ RunTime:0.002462s ]
SHOW TABLES LIKE "tp_module_form" [ RunTime:0.000730s ]
SHOW TABLES LIKE "tp_1_news" [ RunTime:0.003060s ]
show COLUMNS FROM tp_1_news [ RunTime:0.001869s ]
SHOW TABLES LIKE "tp_1_news_data_0" [ RunTime:0.002068s ]
show COLUMNS FROM tp_1_news_data_0 [ RunTime:0.001516s ]
SHOW TABLES LIKE "tp_1_news_category_data" [ RunTime:0.000388s ]
show COLUMNS FROM tp_1_news_category_data [ RunTime:0.001151s ]
SHOW TABLES LIKE "tp_1_news_hits" [ RunTime:0.001737s ]
show COLUMNS FROM tp_1_news_hits [ RunTime:0.000793s ]
SHOW TABLES LIKE "tp_1_news_comment" [ RunTime:0.001610s ]
SHOW TABLES LIKE "tp_1_office" [ RunTime:0.003025s ]
show COLUMNS FROM tp_1_office [ RunTime:0.000866s ]
SHOW TABLES LIKE "tp_1_office_data_0" [ RunTime:0.002569s ]
show COLUMNS FROM tp_1_office_data_0 [ RunTime:0.001476s ]
SHOW TABLES LIKE "tp_1_office_category_data" [ RunTime:0.000907s ]
show COLUMNS FROM tp_1_office_category_data [ RunTime:0.002173s ]
SHOW TABLES LIKE "tp_1_office_hits" [ RunTime:0.003523s ]
show COLUMNS FROM tp_1_office_hits [ RunTime:0.001355s ]
SHOW TABLES LIKE "tp_1_office_comment" [ RunTime:0.000952s ]
SHOW TABLES LIKE "tp_1_build" [ RunTime:0.001104s ]
show COLUMNS FROM tp_1_build [ RunTime:0.001694s ]
SHOW TABLES LIKE "tp_1_build_data_0" [ RunTime:0.004345s ]
show COLUMNS FROM tp_1_build_data_0 [ RunTime:0.003317s ]
SHOW TABLES LIKE "tp_1_build_category_data" [ RunTime:0.000889s ]
show COLUMNS FROM tp_1_build_category_data [ RunTime:0.003676s ]
SHOW TABLES LIKE "tp_1_build_hits" [ RunTime:0.000452s ]
show COLUMNS FROM tp_1_build_hits [ RunTime:0.001295s ]
SHOW TABLES LIKE "tp_1_build_comment" [ RunTime:0.000965s ]
SHOW TABLES LIKE "tp_1_servicedoffice" [ RunTime:0.000538s ]
show COLUMNS FROM tp_1_servicedoffice [ RunTime:0.001605s ]
SHOW TABLES LIKE "tp_1_servicedoffice_data_0" [ RunTime:0.001084s ]
show COLUMNS FROM tp_1_servicedoffice_data_0 [ RunTime:0.002845s ]
SHOW TABLES LIKE "tp_1_servicedoffice_category_data" [ RunTime:0.001076s ]
show COLUMNS FROM tp_1_servicedoffice_category_data [ RunTime:0.001100s ]
SHOW TABLES LIKE "tp_1_servicedoffice_hits" [ RunTime:0.000997s ]
show COLUMNS FROM tp_1_servicedoffice_hits [ RunTime:0.002111s ]
SHOW TABLES LIKE "tp_1_servicedoffice_comment" [ RunTime:0.003224s ]
SHOW TABLES LIKE "tp_1_form" [ RunTime:0.002821s ]
SHOW FULL COLUMNS FROM `tp_1_form` [ RunTime:0.006652s ]
SELECT * FROM `tp_1_form` WHERE 1 [ RunTime:0.003322s ]
show COLUMNS FROM tp_1_form_booking [ RunTime:0.000649s ]
show COLUMNS FROM tp_member [ RunTime:0.000994s ]
show COLUMNS FROM tp_member_data [ RunTime:0.002830s ]
SELECT * FROM `tp_field` WHERE `disabled` = 0 ORDER BY id ASC [ RunTime:0.002620s ]
SHOW FULL COLUMNS FROM `tp_urlrule` [ RunTime:0.003441s ]
SELECT * FROM `tp_urlrule` WHERE 1 [ RunTime:0.005401s ]
SHOW TABLES LIKE "tp_1_share_category" [ RunTime:0.002995s ]
SHOW TABLES LIKE "tp_1_share_index" [ RunTime:0.001644s ]
SELECT * FROM `tp_field` WHERE `disabled` = 0 AND `relatedid` = 1 AND `relatedname` = 'module' ORDER BY displayorder ASC, id ASC [ RunTime:0.007353s ]
show COLUMNS FROM tp_1_share_category [ RunTime:0.002242s ]
SELECT * FROM `tp_field` WHERE `ismain` = 1 AND `disabled` = 0 AND `relatedname` IN ('catmodule-news','catmodule-share') ORDER BY displayorder ASC, id ASC [ RunTime:0.004448s ]
SHOW FULL COLUMNS FROM `tp_admin_menu` [ RunTime:0.005245s ]
SELECT * FROM `tp_admin_menu` WHERE `mark` = 'content-module' LIMIT 1 [ RunTime:0.006257s ]
SELECT * FROM `tp_admin_menu` WHERE `mark` = 'module-news' LIMIT 1 [ RunTime:0.004524s ]
SELECT * FROM `tp_admin_min_menu` WHERE `mark` = 'content-verify' LIMIT 1 [ RunTime:0.000618s ]
SHOW TABLES LIKE "tp_member_menu" [ RunTime:0.000590s ]
SELECT * FROM `tp_field` WHERE `disabled` = 0 AND `relatedid` = 2 AND `relatedname` = 'module' ORDER BY displayorder ASC, id ASC [ RunTime:0.005633s ]
show COLUMNS FROM tp_1_office_category [ RunTime:0.006381s ]
SELECT * FROM `tp_field` WHERE `ismain` = 1 AND `disabled` = 0 AND `relatedname` = 'catmodule-office' ORDER BY displayorder ASC, id ASC [ RunTime:0.005975s ]
SELECT * FROM `tp_admin_menu` WHERE `mark` = 'content-module' LIMIT 1 [ RunTime:0.004673s ]
SELECT * FROM `tp_admin_menu` WHERE `mark` = 'module-office' LIMIT 1 [ RunTime:0.003250s ]
SELECT * FROM `tp_admin_min_menu` WHERE `mark` = 'content-verify' LIMIT 1 [ RunTime:0.001302s ]
SHOW TABLES LIKE "tp_member_menu" [ RunTime:0.001429s ]
SELECT * FROM `tp_field` WHERE `disabled` = 0 AND `relatedid` = 4 AND `relatedname` = 'module' ORDER BY displayorder ASC, id ASC [ RunTime:0.001097s ]
show COLUMNS FROM tp_1_build_category [ RunTime:0.002977s ]
SELECT * FROM `tp_field` WHERE `ismain` = 1 AND `disabled` = 0 AND `relatedname` = 'catmodule-build' ORDER BY displayorder ASC, id ASC [ RunTime:0.000706s ]
SELECT * FROM `tp_admin_menu` WHERE `mark` = 'content-module' LIMIT 1 [ RunTime:0.004496s ]
SELECT * FROM `tp_admin_menu` WHERE `mark` = 'module-build' LIMIT 1 [ RunTime:0.001552s ]
SELECT * FROM `tp_admin_min_menu` WHERE `mark` = 'content-verify' LIMIT 1 [ RunTime:0.000343s ]
SHOW TABLES LIKE "tp_member_menu" [ RunTime:0.000392s ]
SELECT * FROM `tp_field` WHERE `disabled` = 0 AND `relatedid` = 6 AND `relatedname` = 'module' ORDER BY displayorder ASC, id ASC [ RunTime:0.002460s ]
show COLUMNS FROM tp_1_servicedoffice_category [ RunTime:0.006847s ]
SELECT * FROM `tp_field` WHERE `ismain` = 1 AND `disabled` = 0 AND `relatedname` = 'catmodule-servicedoffice' ORDER BY displayorder ASC, id ASC [ RunTime:0.003796s ]
SELECT * FROM `tp_admin_menu` WHERE `mark` = 'content-module' LIMIT 1 [ RunTime:0.005325s ]
SELECT * FROM `tp_admin_menu` WHERE `mark` = 'module-servicedoffice' LIMIT 1 [ RunTime:0.004136s ]
SELECT * FROM `tp_admin_min_menu` WHERE `mark` = 'content-verify' LIMIT 1 [ RunTime:0.000356s ]
SHOW TABLES LIKE "tp_member_menu" [ RunTime:0.000370s ]
SELECT COUNT(*) AS think_count FROM `tp_admin_menu` WHERE `uri` = 'site_config/index' LIMIT 1 [ RunTime:0.002019s ]
SELECT COUNT(*) AS think_count FROM `tp_admin_menu` WHERE `uri` = 'site_mobile/index' LIMIT 1 [ RunTime:0.004482s ]
SELECT COUNT(*) AS think_count FROM `tp_admin_menu` WHERE `uri` = 'site_domain/index' LIMIT 1 [ RunTime:0.005583s ]
SELECT COUNT(*) AS think_count FROM `tp_admin_menu` WHERE `uri` = 'site_image/index' LIMIT 1 [ RunTime:0.002557s ]
SELECT COUNT(*) AS think_count FROM `tp_admin_menu` WHERE `uri` = 'module/site_image/index' LIMIT 1 [ RunTime:0.000639s ]
SELECT COUNT(*) AS think_count FROM `tp_admin_menu` WHERE `uri` = 'site_param/index' LIMIT 1 [ RunTime:0.003029s ]
UPDATE `tp_admin_menu` SET `name` = '网站设置' WHERE ( mark='config-web' ) [ RunTime:0.007848s ]
SELECT * FROM `tp_admin_menu` WHERE `hidden` = 0 ORDER BY displayorder ASC,id ASC [ RunTime:0.001127s ]
SHOW TABLES LIKE "tp_member_menu" [ RunTime:0.003098s ]
SELECT * FROM `tp_admin_min_menu` WHERE `hidden` = 0 ORDER BY displayorder ASC,id ASC [ RunTime:0.001435s ]
select * from `tp_linkage_data_2` where `name` LIKE "%tsing_yi|ap_lei_chau|prince_edward|yuen_long|shek_mun|sai_kung%" [ RunTime:0.009756s ]
SHOW FULL COLUMNS FROM `tp_1_office_search` [ RunTime:0.005728s ]
DELETE FROM `tp_1_office_search` WHERE ( inputtime <1758009556 ) [ RunTime:0.004979s ]
SELECT count(*) as t FROM `tp_1_office` WHERE (`tp_1_office`.`title` LIKE '%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%' OR `tp_1_office`.`keywords` LIKE '%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%' OR `tp_1_office`.`en_title` LIKE '%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%' OR `tp_1_office`.`cn_title` LIKE '%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%' OR `tp_1_office`.`rent` LIKE '%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%' OR `tp_1_office`.`price` LIKE '%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%' OR `tp_1_office`.`area` LIKE '%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%' OR `tp_1_office`.`trade_type` LIKE '%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%' OR `tp_1_office`.`region` LIKE '%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%' OR `tp_1_office`.`letter` LIKE '%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%') AND (`tp_1_office`.`region`=21 OR `tp_1_office`.`region`=26 OR `tp_1_office`.`region`=33) ORDER BY NULL [ RunTime:0.005058s ]
REPLACE INTO `tp_1_office_search` SET `id` = '453bd61b89a8af955ede274d08296406' , `catid` = 0 , `params` = '{\"param\":{\"keyword\":\"租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理\",\"region\":\"tsing_yi|ap_lei_chau|prince_edward|yuen_long|shek_mun|sai_kung\"},\"sql\":\"SELECT `tp_1_office`.`id` FROM `tp_1_office` WHERE (`tp_1_office`.`title` LIKE \'%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%\' OR `tp_1_office`.`keywords` LIKE \'%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%\' OR `tp_1_office`.`en_title` LIKE \'%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%\' OR `tp_1_office`.`cn_title` LIKE \'%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%\' OR `tp_1_office`.`rent` LIKE \'%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%\' OR `tp_1_office`.`price` LIKE \'%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%\' OR `tp_1_office`.`area` LIKE \'%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%\' OR `tp_1_office`.`trade_type` LIKE \'%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%\' OR `tp_1_office`.`region` LIKE \'%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%\' OR `tp_1_office`.`letter` LIKE \'%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%\') AND (`tp_1_office`.`region`=21 OR `tp_1_office`.`region`=26 OR `tp_1_office`.`region`=33) ORDER BY NULL \",\"where\":\"(`tp_1_office`.`title` LIKE \'%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%\' OR `tp_1_office`.`keywords` LIKE \'%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%\' OR `tp_1_office`.`en_title` LIKE \'%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%\' OR `tp_1_office`.`cn_title` LIKE \'%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%\' OR `tp_1_office`.`rent` LIKE \'%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%\' OR `tp_1_office`.`price` LIKE \'%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%\' OR `tp_1_office`.`area` LIKE \'%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%\' OR `tp_1_office`.`trade_type` LIKE \'%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%\' OR `tp_1_office`.`region` LIKE \'%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%\' OR `tp_1_office`.`letter` LIKE \'%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%\') AND (`tp_1_office`.`region`=21 OR `tp_1_office`.`region`=26 OR `tp_1_office`.`region`=33)\"}' , `keyword` = '租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理' , `contentid` = 6 , `inputtime` = 1758013156 [ RunTime:0.012406s ]
SELECT * FROM `tp_1_office` WHERE (`tp_1_office`.`title` LIKE '%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%' OR `tp_1_office`.`keywords` LIKE '%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%' OR `tp_1_office`.`en_title` LIKE '%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%' OR `tp_1_office`.`cn_title` LIKE '%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%' OR `tp_1_office`.`rent` LIKE '%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%' OR `tp_1_office`.`price` LIKE '%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%' OR `tp_1_office`.`area` LIKE '%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%' OR `tp_1_office`.`trade_type` LIKE '%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%' OR `tp_1_office`.`region` LIKE '%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%' OR `tp_1_office`.`letter` LIKE '%租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理%') AND (`tp_1_office`.`region`=21 OR `tp_1_office`.`region`=26 OR `tp_1_office`.`region`=33) LIMIT 0,16 [ RunTime:0.028777s ]
