SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 350006 LIMIT 1 [ RunTime:0.000497s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 350006 [ RunTime:0.004389s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1048450,523532,1040849,967443,998236,1031451,651403,613036,26152,875324,284475,1999,865480,313140,986539,28918,878400,749847,339857,299344,806979,729738,35215,257858,897814,437639,124374,265642,502351,597771,629766,940312,612055,636200,60385,31767,211338,612397,592150,878404,249793,432640,978550,807200,291293,216706,72111,1009557,463682,404493,650395,941986,647774,551624,465132,758185,54533,591963,859913,818789) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004738s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 350006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 350006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004220s ]