SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461999 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461999 [ RunTime:0.001647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (401823,869079,753005,926471,184473,145534,583306,763519,711354,53548,824177,602101,979303,27871,262523,239942,164813,358935,832188,804923,748628,169603,511348,904056,563170,539986,574431,232033,63126,400165,510825,1034663,210892,75809,860917,206009,575351,35230,424760,478630,458888,670463,55057,471576,161707,519062,161174,851933,449761,585910,378425,433228,643722,393810,46894,878377,15925,675824,680036,528808) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461999 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461999 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000366s ]