SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196696 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196696 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (62687,284420,914899,279037,861795,61627,928485,484774,870286,615050,13621,776342,336512,412669,241565,127080,117948,671089,494929,1020908,259908,373192,429391,685354,381968,185599,876278,163513,346381,507964,262448,1040214,365041,568710,4054,551648,260310,985617,203879,1031640,346263,74584,394268,813374,241761,14142,613055,691460,1027843,667864,350069,786611,303947,639710,941428,205056,1002264,746435,995194,973246) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196696 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196696 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]