set session sql_mode='NO_ENGINE_SUBSTITUTION' [ RunTime:0.001932s ]
SHOW FULL COLUMNS FROM `tp_linkage_data_2` [ RunTime:0.001512s ]
SELECT `id`,`pid`,`name`,`cname`,`en_name`,`cn_name` FROM `tp_linkage_data_2` [ RunTime:0.000334s ]
select version() [ RunTime:0.000312s ]
SHOW FULL COLUMNS FROM `tp_1_industrial_search` [ RunTime:0.000884s ]
DELETE FROM `tp_1_industrial_search` WHERE ( inputtime <1761802352 ) [ RunTime:0.003646s ]
SELECT count(*) as t FROM `tp_1_industrial` WHERE ((CASE WHEN JSON_VALID(`tp_1_industrial`.`trade_type`) THEN JSON_CONTAINS (`tp_1_industrial`.`trade_type`->'$[*]', '"1"', '$') ELSE null END)) ORDER BY NULL [ RunTime:0.003991s ]
REPLACE INTO `tp_1_industrial_search` SET `id` = '5275044c89c00360b4e8928d6af7cc6c' , `catid` = 0 , `params` = '{\"param\":{\"trade_type\":\"1\"},\"sql\":\"SELECT `tp_1_industrial`.`id` FROM `tp_1_industrial` WHERE ((CASE WHEN JSON_VALID(`tp_1_industrial`.`trade_type`) THEN JSON_CONTAINS (`tp_1_industrial`.`trade_type`->\'$[*]\', \'\\\"1\\\"\', \'$\') ELSE null END)) ORDER BY NULL \",\"where\":\"((CASE WHEN JSON_VALID(`tp_1_industrial`.`trade_type`) THEN JSON_CONTAINS (`tp_1_industrial`.`trade_type`->\'$[*]\', \'\\\"1\\\"\', \'$\') ELSE null END))\"}' , `keyword` = '' , `contentid` = 454 , `inputtime` = 1761805952 [ RunTime:0.004463s ]
SELECT * FROM `tp_1_industrial` WHERE ((CASE WHEN JSON_VALID(`tp_1_industrial`.`trade_type`) THEN JSON_CONTAINS (`tp_1_industrial`.`trade_type`->'$[*]', '"1"', '$') ELSE null END)) ORDER BY `tp_1_industrial`.`floor_area` DESC LIMIT 0,16 [ RunTime:0.004916s ]
