SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405964 LIMIT 1 [ RunTime:0.000277s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405964 [ RunTime:0.001959s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (670263,838907,320109,939716,992767,266266,270694,429218,740649,249909,272584,831312,998012,604873,202633,493595,1044801,379903,746616,469071,729919,444221,845635,842422,997311,294467,423321,142022,824024,839488,531519,1021338,999875,853126,359467,645252,221311,754797,640502,736479,996219,172660,503522,561895,1002725,85139,384796,881136,942081,244466,710078,298355,880762,1031670,498251,163072,133014,500262,821643,532192) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405964 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405964 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005026s ]