SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414380 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414380 [ RunTime:0.001952s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (818215,582129,173386,956627,295745,691675,780717,231945,945687,571209,522229,965333,23590,462825,379406,152591,113184,926333,450006,911735,966803,672675,960689,381090,667061,445787,50624,485181,911493,121161,1015497,492085,687522,72320,77019,230831,939054,483901,657011,494219,52532,298722,75300,67128,792171,1036764,28061,677118,440600,153070,846317,701440,1027723,817899,558750,68225,568794,78343,1006838,492810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001929s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000500s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]