SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001733s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 293428 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 293428 [ RunTime:0.002713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (442472,811322,290337,74433,150461,1024300,835645,92456,644509,1021319,296958,128126,429279,397339,30103,979523,336081,350690,167995,182143,252915,242750,152459,1032384,342289,471445,599017,294858,560157,638572,37429,284527,462923,94998,58631,535359,458346,969500,413557,230336,474928,755729,804732,238,120386,214227,302621,620134,337007,828092,167662,96399,293648,834190,763957,939289,585374,751875,134692,17348) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 293428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 293428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000691s ]