SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517952 LIMIT 1 [ RunTime:0.000560s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517952 [ RunTime:0.002877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (856482,436451,857508,244916,297410,1008904,647950,776873,649741,447306,1025258,269214,773852,635965,509375,1041410,884741,1040487,912335,93388,649049,924350,42079,47779,672081,427530,717142,285564,880739,853899,724186,46714,39081,867930,38829,781920,10899,582013,471215,860383,596928,1004161,636459,306281,606861,125538,938587,648235,998648,786005,233076,743589,960820,149255,758746,174829,797610,618493,1017019,626516) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517952 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517952 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000752s ]