SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002003s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019250 LIMIT 1 [ RunTime:0.002368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019250 [ RunTime:0.005391s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342480,153380,613951,833623,485581,791996,369387,850882,225392,52879,849594,833005,128895,406804,1003632,510057,620008,195378,949491,669961,500918,146324,264396,23641,1005270,828231,106734,898898,310410,183969,809625,41789,134263,837302,6231,211123,352312,531464,391318,649323,527357,6984,849858,879534,616572,801172,766155,702499,608375,1022405,589668,1005282,307899,333646,758718,478227,469659,598565,46939,1036407) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019250 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019250 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]