SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002866s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 479843 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 479843 [ RunTime:0.002350s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1042677,605715,578536,712887,281063,435375,858627,84486,269738,23809,596851,316172,788276,956922,321927,170074,513426,303779,325585,604716,306596,527689,166005,978251,984623,649401,183742,68614,1016673,889254,495627,967131,642678,478058,591177,436717,410490,606838,921399,734734,789931,571708,98724,606997,357531,479904,945443,928640,955727,879946,694253,59452,721555,61432,282689,531218,865753,655225,205056,268373) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 479843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 479843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]