SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046108 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046108 [ RunTime:0.001798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417125,35920,950765,77407,8410,523287,904203,621053,199243,690350,1023568,460149,118209,637251,941979,259219,353368,1010253,416117,810364,435328,897495,77226,604596,392989,83458,179480,519573,575503,169096,214631,57970,1022906,489207,581337,1043938,294382,695823,422596,789504,503322,26866,392347,879252,656470,937353,2374,514864,583032,193226,826282,442646,977393,56915,240098,337036,462852,766996,439166,14321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]