SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004969s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455570 LIMIT 1 [ RunTime:0.000523s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455570 [ RunTime:0.003263s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (34047,736212,339629,510179,473978,466820,39745,968117,611145,860743,80837,643300,316113,137399,566691,145602,876519,658737,179431,665816,606982,286473,829656,201431,57732,265278,548838,382709,959516,856859,46642,606447,452406,735060,546145,891153,502015,140518,638751,879252,279946,576602,134657,954629,971285,267425,799545,765922,563304,233407,868222,988808,1020649,989769,366519,182802,301207,432663,914235,876800) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001288s ]