SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 654310 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 654310 [ RunTime:0.003719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (251442,931795,254309,49249,401760,786018,783807,394938,193403,601913,56197,556811,541729,840748,270092,841136,316851,931650,89285,250151,916362,900101,519128,103244,591986,218130,776366,645889,581986,887749,841393,299970,382548,269446,94968,582220,657757,417083,844852,704559,1037006,764859,130194,53856,1111,1004023,530155,385897,914933,421245,280420,108665,769685,1037691,260379,75626,75267,706743,613083,331024) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 654310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 654310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]