set session sql_mode='NO_ENGINE_SUBSTITUTION' [ RunTime:0.000261s ]
SHOW FULL COLUMNS FROM `tp_linkage_data_2` [ RunTime:0.000717s ]
SELECT `id`,`pid`,`name`,`cname`,`en_name`,`cn_name` FROM `tp_linkage_data_2` [ RunTime:0.000382s ]
select version() [ RunTime:0.000359s ]
SHOW FULL COLUMNS FROM `tp_1_industrial_search` [ RunTime:0.003004s ]
DELETE FROM `tp_1_industrial_search` WHERE ( inputtime <1761802619 ) [ RunTime:0.003773s ]
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.004364s ]
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` = 1761806219 [ RunTime:0.003737s ]
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 16,16 [ RunTime:0.004665s ]
