SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001949s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411409 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411409 [ RunTime:0.004512s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (39842,782373,532148,967819,949594,353657,508722,636091,767040,232007,75097,1012147,657146,1048223,491105,392565,1024266,828959,971619,938972,111694,609811,53366,649922,334890,214481,150131,654208,35724,960499,152903,150241,841619,538662,852584,657464,643408,868693,82953,673754,573888,88683,550209,243339,417415,760028,559536,635461,466771,34471,403594,965084,571923,174485,189766,294067,447222,229451,308454,443416) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001736s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001397s ]