SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495914 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495914 [ RunTime:0.002444s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (190314,593429,892470,1026312,964827,962807,884941,933301,405932,350845,881574,407267,141791,1003796,591063,905823,737144,182690,143209,257911,234185,657601,971637,305278,914259,649876,817689,1020821,410345,588016,770070,626544,544477,716920,422224,80128,752915,13208,126625,467157,766361,103591,1004948,614842,792599,271026,682579,815871,113398,783393,737354,607320,602131,354593,872780,815804,6803,659229,809595,1011667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]