SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1008148 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1008148 [ RunTime:0.002406s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (386289,591088,525126,220786,1023866,393506,283082,415170,576153,229055,782109,238567,228850,389500,864960,187459,912914,556112,951328,46317,592197,928382,161441,330853,360779,678838,500523,448414,470858,573415,998061,320122,1047790,144190,809936,626465,756467,533600,748461,42449,254429,765690,108337,226898,503128,882400,115587,807984,960036,406892,479671,581146,381805,612902,647925,436986,647945,774954,263322,742266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1008148 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000534s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1008148 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]