SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291178 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291178 [ RunTime:0.001924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539751,648583,356576,747023,1009513,862474,344152,351485,817732,408840,303248,935596,996655,916500,722080,289560,550773,109020,109050,242870,573554,259125,637777,461574,60160,65178,944492,634185,284807,389667,641117,193830,591219,486155,628557,604092,596855,854991,822276,247327,720888,72549,583274,5702,880691,855195,989758,840949,757954,393956,169002,797835,476074,556603,118437,311147,552328,1001527,999107,267175) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291178 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291178 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]