SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000923s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 49102 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 49102 [ RunTime:0.001640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401708,94823,715847,261079,398832,194902,867187,390751,914459,1037532,161204,739694,317071,265879,359224,1019271,559434,841628,945542,995128,826191,890740,287056,942091,1015733,424671,121529,1036374,857414,580908,749375,755441,916770,506725,612650,833633,914492,647439,950890,175356,161287,648937,606359,263414,632198,465109,547248,396227,905820,652312,717270,1010532,257832,534067,887890,124395,262820,547080,437542,870887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 49102 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 49102 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000691s ]