set session sql_mode='NO_ENGINE_SUBSTITUTION' [ RunTime:0.003003s ]
SHOW FULL COLUMNS FROM `tp_linkage_data_2` [ RunTime:0.001638s ]
SELECT `id`,`pid`,`name`,`cname`,`en_name`,`cn_name` FROM `tp_linkage_data_2` [ RunTime:0.000318s ]
SHOW FULL COLUMNS FROM `tp_site` [ RunTime:0.012740s ]
SELECT * FROM `tp_site` WHERE `disabled` = 0 [ RunTime:0.000347s ]
SHOW FULL COLUMNS FROM `tp_module` [ RunTime:0.000501s ]
SELECT * FROM `tp_module` WHERE 1 ORDER BY displayorder ASC,id ASC [ RunTime:0.000284s ]
SHOW TABLES LIKE "tp_module_form" [ RunTime:0.008873s ]
SHOW TABLES LIKE "tp_1_news" [ RunTime:0.000467s ]
show COLUMNS FROM tp_1_news [ RunTime:0.000891s ]
SHOW TABLES LIKE "tp_1_news_data_0" [ RunTime:0.000396s ]
show COLUMNS FROM tp_1_news_data_0 [ RunTime:0.000653s ]
SHOW TABLES LIKE "tp_1_news_category_data" [ RunTime:0.000408s ]
show COLUMNS FROM tp_1_news_category_data [ RunTime:0.000619s ]
SHOW TABLES LIKE "tp_1_news_hits" [ RunTime:0.000527s ]
show COLUMNS FROM tp_1_news_hits [ RunTime:0.000566s ]
SHOW TABLES LIKE "tp_1_news_comment" [ RunTime:0.000413s ]
SHOW TABLES LIKE "tp_1_office" [ RunTime:0.000360s ]
show COLUMNS FROM tp_1_office [ RunTime:0.000937s ]
SHOW TABLES LIKE "tp_1_office_data_0" [ RunTime:0.000379s ]
show COLUMNS FROM tp_1_office_data_0 [ RunTime:0.000638s ]
SHOW TABLES LIKE "tp_1_office_category_data" [ RunTime:0.000473s ]
show COLUMNS FROM tp_1_office_category_data [ RunTime:0.000587s ]
SHOW TABLES LIKE "tp_1_office_hits" [ RunTime:0.000530s ]
show COLUMNS FROM tp_1_office_hits [ RunTime:0.001108s ]
SHOW TABLES LIKE "tp_1_office_comment" [ RunTime:0.001636s ]
SHOW TABLES LIKE "tp_1_build" [ RunTime:0.000351s ]
show COLUMNS FROM tp_1_build [ RunTime:0.001033s ]
SHOW TABLES LIKE "tp_1_build_data_0" [ RunTime:0.000454s ]
show COLUMNS FROM tp_1_build_data_0 [ RunTime:0.000526s ]
SHOW TABLES LIKE "tp_1_build_category_data" [ RunTime:0.000429s ]
show COLUMNS FROM tp_1_build_category_data [ RunTime:0.000578s ]
SHOW TABLES LIKE "tp_1_build_hits" [ RunTime:0.000353s ]
show COLUMNS FROM tp_1_build_hits [ RunTime:0.000481s ]
SHOW TABLES LIKE "tp_1_build_comment" [ RunTime:0.000480s ]
SHOW TABLES LIKE "tp_1_servicedoffice" [ RunTime:0.000572s ]
show COLUMNS FROM tp_1_servicedoffice [ RunTime:0.002016s ]
SHOW TABLES LIKE "tp_1_servicedoffice_data_0" [ RunTime:0.000380s ]
show COLUMNS FROM tp_1_servicedoffice_data_0 [ RunTime:0.000624s ]
SHOW TABLES LIKE "tp_1_servicedoffice_category_data" [ RunTime:0.000396s ]
show COLUMNS FROM tp_1_servicedoffice_category_data [ RunTime:0.000562s ]
SHOW TABLES LIKE "tp_1_servicedoffice_hits" [ RunTime:0.001091s ]
show COLUMNS FROM tp_1_servicedoffice_hits [ RunTime:0.000533s ]
SHOW TABLES LIKE "tp_1_servicedoffice_comment" [ RunTime:0.000455s ]
SHOW TABLES LIKE "tp_1_form" [ RunTime:0.000869s ]
SHOW FULL COLUMNS FROM `tp_1_form` [ RunTime:0.000472s ]
SELECT * FROM `tp_1_form` WHERE 1 [ RunTime:0.000441s ]
show COLUMNS FROM tp_1_form_booking [ RunTime:0.000640s ]
show COLUMNS FROM tp_member [ RunTime:0.000620s ]
show COLUMNS FROM tp_member_data [ RunTime:0.000432s ]
SHOW FULL COLUMNS FROM `tp_field` [ RunTime:0.000647s ]
SELECT * FROM `tp_field` WHERE `disabled` = 0 ORDER BY id ASC [ RunTime:0.000739s ]
SHOW FULL COLUMNS FROM `tp_urlrule` [ RunTime:0.003617s ]
SELECT * FROM `tp_urlrule` WHERE 1 [ RunTime:0.000284s ]
SHOW TABLES LIKE "tp_1_share_category" [ RunTime:0.000601s ]
SHOW TABLES LIKE "tp_1_share_index" [ RunTime:0.000537s ]
SELECT * FROM `tp_field` WHERE `disabled` = 0 AND `relatedid` = 1 AND `relatedname` = 'module' ORDER BY displayorder ASC, id ASC [ RunTime:0.003229s ]
show COLUMNS FROM tp_1_share_category [ RunTime:0.000870s ]
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.000476s ]
SHOW FULL COLUMNS FROM `tp_admin_menu` [ RunTime:0.001074s ]
SELECT * FROM `tp_admin_menu` WHERE `mark` = 'content-module' LIMIT 1 [ RunTime:0.001438s ]
SELECT * FROM `tp_admin_menu` WHERE `mark` = 'module-news' LIMIT 1 [ RunTime:0.003179s ]
SELECT * FROM `tp_admin_min_menu` WHERE `mark` = 'content-verify' LIMIT 1 [ RunTime:0.000490s ]
SHOW TABLES LIKE "tp_member_menu" [ RunTime:0.000543s ]
SELECT * FROM `tp_field` WHERE `disabled` = 0 AND `relatedid` = 2 AND `relatedname` = 'module' ORDER BY displayorder ASC, id ASC [ RunTime:0.001032s ]
show COLUMNS FROM tp_1_office_category [ RunTime:0.000934s ]
SELECT * FROM `tp_field` WHERE `ismain` = 1 AND `disabled` = 0 AND `relatedname` = 'catmodule-office' ORDER BY displayorder ASC, id ASC [ RunTime:0.000734s ]
SELECT * FROM `tp_admin_menu` WHERE `mark` = 'content-module' LIMIT 1 [ RunTime:0.000636s ]
SELECT * FROM `tp_admin_menu` WHERE `mark` = 'module-office' LIMIT 1 [ RunTime:0.000467s ]
SELECT * FROM `tp_admin_min_menu` WHERE `mark` = 'content-verify' LIMIT 1 [ RunTime:0.000473s ]
SHOW TABLES LIKE "tp_member_menu" [ RunTime:0.000458s ]
SELECT * FROM `tp_field` WHERE `disabled` = 0 AND `relatedid` = 4 AND `relatedname` = 'module' ORDER BY displayorder ASC, id ASC [ RunTime:0.001364s ]
show COLUMNS FROM tp_1_build_category [ RunTime:0.001153s ]
SELECT * FROM `tp_field` WHERE `ismain` = 1 AND `disabled` = 0 AND `relatedname` = 'catmodule-build' ORDER BY displayorder ASC, id ASC [ RunTime:0.000596s ]
SELECT * FROM `tp_admin_menu` WHERE `mark` = 'content-module' LIMIT 1 [ RunTime:0.000967s ]
SELECT * FROM `tp_admin_menu` WHERE `mark` = 'module-build' LIMIT 1 [ RunTime:0.000836s ]
SELECT * FROM `tp_admin_min_menu` WHERE `mark` = 'content-verify' LIMIT 1 [ RunTime:0.000641s ]
SHOW TABLES LIKE "tp_member_menu" [ RunTime:0.000440s ]
SELECT * FROM `tp_field` WHERE `disabled` = 0 AND `relatedid` = 6 AND `relatedname` = 'module' ORDER BY displayorder ASC, id ASC [ RunTime:0.000722s ]
show COLUMNS FROM tp_1_servicedoffice_category [ RunTime:0.000693s ]
SELECT * FROM `tp_field` WHERE `ismain` = 1 AND `disabled` = 0 AND `relatedname` = 'catmodule-servicedoffice' ORDER BY displayorder ASC, id ASC [ RunTime:0.000534s ]
SELECT * FROM `tp_admin_menu` WHERE `mark` = 'content-module' LIMIT 1 [ RunTime:0.000368s ]
SELECT * FROM `tp_admin_menu` WHERE `mark` = 'module-servicedoffice' LIMIT 1 [ RunTime:0.000313s ]
SELECT * FROM `tp_admin_min_menu` WHERE `mark` = 'content-verify' LIMIT 1 [ RunTime:0.000407s ]
SHOW TABLES LIKE "tp_member_menu" [ RunTime:0.000449s ]
SELECT COUNT(*) AS think_count FROM `tp_admin_menu` WHERE `uri` = 'site_config/index' LIMIT 1 [ RunTime:0.000437s ]
SELECT COUNT(*) AS think_count FROM `tp_admin_menu` WHERE `uri` = 'site_mobile/index' LIMIT 1 [ RunTime:0.000831s ]
SELECT COUNT(*) AS think_count FROM `tp_admin_menu` WHERE `uri` = 'site_domain/index' LIMIT 1 [ RunTime:0.000267s ]
SELECT COUNT(*) AS think_count FROM `tp_admin_menu` WHERE `uri` = 'site_image/index' LIMIT 1 [ RunTime:0.000273s ]
SELECT COUNT(*) AS think_count FROM `tp_admin_menu` WHERE `uri` = 'module/site_image/index' LIMIT 1 [ RunTime:0.000329s ]
SELECT COUNT(*) AS think_count FROM `tp_admin_menu` WHERE `uri` = 'site_param/index' LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tp_admin_menu` SET `name` = '网站设置' WHERE ( mark='config-web' ) [ RunTime:0.003773s ]
SELECT * FROM `tp_admin_menu` WHERE `hidden` = 0 ORDER BY displayorder ASC,id ASC [ RunTime:0.000831s ]
SHOW TABLES LIKE "tp_member_menu" [ RunTime:0.000491s ]
SELECT * FROM `tp_admin_min_menu` WHERE `hidden` = 0 ORDER BY displayorder ASC,id ASC [ RunTime:0.000538s ]
select * from `tp_linkage_data_2` where `name` LIKE "%ap_lei_chau|shek_mun|admiralty|tin_hau|tsim_sha_tsui|yuen_long|tsing_yi%" [ RunTime:0.000573s ]
SHOW FULL COLUMNS FROM `tp_1_office_search` [ RunTime:0.000700s ]
DELETE FROM `tp_1_office_search` WHERE ( inputtime <1758185218 ) [ RunTime:0.003017s ]
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`=33 OR `tp_1_office`.`region`=5 OR `tp_1_office`.`region`=16 OR `tp_1_office`.`region`=26) ORDER BY NULL [ RunTime:0.005664s ]
REPLACE INTO `tp_1_office_search` SET `id` = '105f24e2c8a108042eb944340a16d993' , `catid` = 0 , `params` = '{\"param\":{\"keyword\":\"租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理\",\"region\":\"ap_lei_chau|shek_mun|admiralty|tin_hau|tsim_sha_tsui|yuen_long|tsing_yi\"},\"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`=33 OR `tp_1_office`.`region`=5 OR `tp_1_office`.`region`=16 OR `tp_1_office`.`region`=26) 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`=33 OR `tp_1_office`.`region`=5 OR `tp_1_office`.`region`=16 OR `tp_1_office`.`region`=26)\"}' , `keyword` = '租寫字樓、寫字樓出租、租屋、租樓、服務式辦公室、服務式住宅、地產代理' , `contentid` = 278 , `inputtime` = 1758188818 [ RunTime:0.004178s ]
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`=33 OR `tp_1_office`.`region`=5 OR `tp_1_office`.`region`=16 OR `tp_1_office`.`region`=26) LIMIT 64,16 [ RunTime:0.003344s ]
