SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484217 LIMIT 1 [ RunTime:0.000459s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484217 [ RunTime:0.002484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (591801,810914,746694,331958,118651,851275,383690,846730,790139,636800,266620,365127,349662,244267,6792,188435,504486,925706,761958,79205,1026111,91969,787484,764147,818734,680405,416534,338180,879200,87929,426744,311163,978469,801033,503428,933654,358654,909325,80096,976382,796914,709290,1027244,344708,1024333,1037662,293285,998631,972509,924120,268347,241073,976088,1041031,786706,814197,258664,1048441,837941,1004989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000415s ]