SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001550s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 254451 LIMIT 1 [ RunTime:0.002561s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 254451 [ RunTime:0.003506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (672573,789813,242309,479116,978341,321993,410167,235568,60321,505296,463366,628686,324002,352009,863970,802984,83758,514830,109366,490954,982867,834619,173918,856458,223,220279,143686,964735,298932,765004,856710,406481,4796,867466,913065,447889,27975,115459,763165,285179,269463,588653,807223,720690,564869,156343,990619,582295,616312,93910,784778,943944,410321,97824,51960,160870,817130,893146,279538,698303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 254451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 254451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002341s ]