SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480917 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480917 [ RunTime:0.001842s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403554,684177,864422,1032442,357147,722672,489189,352543,932532,214222,809086,473320,706653,538194,729288,953344,335997,1042512,595356,795845,994168,787803,477543,169625,899483,1026759,336049,151881,987130,943465,255195,488006,597628,605466,968246,387962,103232,17498,309866,648939,479775,863154,593789,713400,729106,630963,996813,212481,487004,592142,928310,219509,643442,577617,583819,366886,224526,722692,751772,664166) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]