set session sql_mode='NO_ENGINE_SUBSTITUTION' [ RunTime:0.002008s ]
SHOW FULL COLUMNS FROM `tp_linkage_data_2` [ RunTime:0.001290s ]
SELECT `id`,`pid`,`name`,`cname`,`en_name`,`cn_name` FROM `tp_linkage_data_2` [ RunTime:0.000663s ]
select version() [ RunTime:0.000306s ]
SHOW FULL COLUMNS FROM `tp_1_industrial_search` [ RunTime:0.000798s ]
DELETE FROM `tp_1_industrial_search` WHERE ( inputtime <1761755908 ) [ RunTime:0.003968s ]
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.003863s ]
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` = 1761759508 [ RunTime:0.003809s ]
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`.`updatetime` DESC LIMIT 0,16 [ RunTime:0.003847s ]
