SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40421 LIMIT 1 [ RunTime:0.000577s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40421 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (968592,805667,977479,35532,816508,192065,359672,537055,177040,866403,915443,100332,18832,941645,973604,537498,857168,232727,943557,611122,1013311,1018646,367187,671479,939403,697622,63296,219380,827257,1009510,980853,93615,41868,858067,241819,681632,510046,4132,959340,939970,28729,468758,793724,367672,273959,95311,472478,558240,910032,929192,347545,914229,487852,852218,234313,739632,565205,188456,599446,601739) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]