SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489823 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489823 [ RunTime:0.001987s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (984930,699904,261924,53316,418526,132790,948636,988574,147590,922448,751997,648235,638810,603467,850015,251964,462227,301517,7783,531745,190448,340443,510451,370725,656646,720789,498639,60897,870871,1010075,1030267,119573,765469,400960,980948,524994,344129,88061,226270,565073,127261,747673,270136,184728,531476,582215,426157,22206,661195,925521,346841,234188,432139,664615,612418,542868,200656,1018212,37548,92833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]