SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536903 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536903 [ RunTime:0.001879s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474918,496775,408620,654172,211302,811614,818864,256321,242057,430410,608510,996845,603471,481130,820044,234291,873341,159440,228915,645093,16237,438776,444353,1038146,525215,408160,102261,133754,483223,563967,468568,75522,506589,947078,155705,442057,125905,367075,587949,997269,301910,991838,19126,998298,997860,415676,340294,93409,269418,895174,126900,581329,327471,399873,235326,167809,1038070,826742,808285,333645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001940s ]