SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401911 LIMIT 1 [ RunTime:0.001805s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401911 [ RunTime:0.004445s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286892,70170,866939,933691,998463,164720,135659,345031,125202,740140,148672,1039066,268176,142377,850473,648549,697628,534097,621100,43597,788968,472791,311566,11264,567016,608279,285633,877309,702228,954152,52866,609334,691965,310719,435877,596323,582951,926709,758688,352872,746655,700124,378601,292767,156978,17007,493827,331925,935059,417802,890629,687135,807214,557734,861728,137415,488091,662004,423375,321697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001424s ]