SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509219 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509219 [ RunTime:0.002010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (52687,522808,588928,513918,367510,118993,1038919,932001,890433,522472,288029,967425,201463,373628,111084,169096,660377,815785,179833,489526,30319,408244,456349,545282,67439,207176,356850,1030322,806900,550445,951702,135460,495696,490760,970985,93206,187891,729235,749388,363383,455984,271717,260138,690822,858223,632825,799397,130887,333612,542301,768639,364407,609918,188904,556537,922443,816951,14019,442789,467449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509219 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509219 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]