SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 209583 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 209583 [ RunTime:0.001544s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1038855,832696,97077,2937,194741,692563,367820,990256,631083,597985,600169,1013184,180060,616221,379853,369460,342906,579889,230551,382860,344310,180515,127655,148827,1024363,639496,405451,320268,966093,553246,21966,150890,955568,334968,1045346,924453,24099,231859,517563,336521,1003659,1044824,114221,742784,433775,836973,910543,640502,231884,756078,328861,709827,636836,194790,537219,840102,1044262,1026731,992381,3674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 209583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 209583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]