SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480447 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480447 [ RunTime:0.001827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018717,363727,378249,657172,969097,1015075,991752,648309,717506,1017715,150853,981730,776545,997238,879948,603546,104362,486795,816958,997925,370548,1031431,745140,936864,263452,931308,79126,634358,975064,489642,259063,965050,873926,288443,131814,211526,485357,898234,515393,482597,465227,915254,560078,43518,344342,818266,652896,1037505,446950,274287,198524,151361,993696,550195,419045,552169,881732,651859,321684,694719) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480447 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480447 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000774s ]