SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001479s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011811 LIMIT 1 [ RunTime:0.003624s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011811 [ RunTime:0.007061s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (329335,102201,465395,764503,1006162,138313,746278,709888,426545,657374,419632,167326,1012239,483024,324382,940659,171830,1003426,447878,343923,602631,637939,338397,602117,544611,697140,313423,844587,477201,723718,43595,456176,375973,900391,669514,19952,141852,365117,461899,734003,228105,801452,712568,37342,166035,732428,796699,226581,921229,211451,301648,430018,804962,914423,560286,1024817,175859,566578,415927,618610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011811 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001672s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011811 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000797s ]