SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468325 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468325 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24776,770142,997741,1431,266455,198424,683135,464134,132547,373714,391823,25596,733131,224985,927840,258803,736120,576945,87885,700119,1032579,36836,367240,563088,870858,224079,466105,418393,904570,550980,550743,720822,371085,850877,776203,110462,774325,878705,96905,304207,104789,469298,22851,646851,511709,618527,814587,733312,570142,891048,929491,906117,1042097,1042350,691622,865231,839479,476319,340119,763742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468325 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468325 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]