SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 487911 LIMIT 1 [ RunTime:0.002289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 487911 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254901,23207,740684,821713,950127,278293,517904,963030,787920,578550,889633,1018361,70207,98340,68743,147397,561825,769634,449195,290784,722463,64010,473094,1015936,1032960,751490,257800,820979,593169,76275,574928,216979,331424,107140,952594,136498,1034731,317745,564225,165850,389677,266954,1009953,412277,877085,551030,35281,706568,781694,15812,578365,222631,864608,226398,582408,665198,607032,591890,235308,3784) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004766s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 487911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001939s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 487911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]