set session sql_mode='NO_ENGINE_SUBSTITUTION' [ RunTime:0.002060s ]
SHOW FULL COLUMNS FROM `tp_linkage_data_2` [ RunTime:0.001345s ]
SELECT `id`,`pid`,`name`,`cname`,`en_name`,`cn_name` FROM `tp_linkage_data_2` [ RunTime:0.001695s ]
select version() [ RunTime:0.001282s ]
SHOW FULL COLUMNS FROM `tp_1_industrial_search` [ RunTime:0.000996s ]
DELETE FROM `tp_1_industrial_search` WHERE ( inputtime <1761802356 ) [ RunTime:0.002642s ]
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.004148s ]
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` = 1761805956 [ RunTime:0.004345s ]
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 64,16 [ RunTime:0.005295s ]
