SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475916 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475916 [ RunTime:0.001799s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (626339,702578,1013062,343046,815400,923871,332911,108644,68940,1036935,847751,309289,269913,670628,559100,832415,548010,409853,1821,734981,608212,910185,842199,760002,828152,253739,772603,364773,579083,420548,1042040,264372,385952,184361,228777,526899,186922,177751,253498,218915,888189,724128,334880,577453,490871,537950,546507,577118,988070,392952,626235,862843,521138,977743,968144,819843,751552,1043233,178486,384136) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]