SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 255880 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 255880 [ RunTime:0.001539s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819916,159791,53005,77041,390626,667087,160802,563511,957387,373307,157520,1008724,324413,145500,42159,415212,249415,779910,101090,561786,134997,290321,165660,631284,138729,668627,507712,767705,650234,107205,160578,657971,974301,927546,87366,787437,619233,24424,157461,1015616,121573,227995,431004,267831,435808,675374,15487,53596,808985,30587,673287,821851,69137,461809,438374,188945,467321,620815,143142,148234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000931s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 255880 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 255880 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000635s ]