SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 376748 LIMIT 1 [ RunTime:0.000803s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 376748 [ RunTime:0.002136s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6940,168023,1024700,311758,199327,675886,169284,113296,17105,481854,917578,1027192,950161,613622,592075,75193,1000898,812798,107615,976775,258912,958420,436726,905116,395941,966217,291859,539566,973031,131480,998693,112619,418762,284371,249730,494426,664209,643276,1009300,868208,607744,347297,783885,753634,368880,322780,856006,1019694,472130,596865,264137,1031549,524558,707188,673672,241629,690658,336082,268546,255397) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001557s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 376748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004876s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 376748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000688s ]