SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001507s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042126 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042126 [ RunTime:0.003282s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664675,401263,925390,470441,1016270,889565,856815,946538,787215,943097,256769,743201,872098,334662,259042,447715,141044,896687,368313,1038352,101625,420055,594103,926505,210084,127646,451583,521315,913587,876339,109525,977616,485342,148676,723459,523019,74420,197436,731834,615762,862118,15654,240869,684938,612819,537465,231343,209774,735920,206925,509010,458167,338110,993133,438267,608284,591285,493088,648064,306350) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042126 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042126 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]