SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477313 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477313 [ RunTime:0.004672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (33574,571668,57690,35835,237483,451807,471652,800870,437073,621537,287721,838921,542410,660903,42594,42918,608168,563122,933586,835596,780252,652485,598616,1003332,89388,397914,573033,885213,491125,91870,490368,307066,80024,815058,960597,924446,803879,809162,835598,49321,818693,814739,1002013,479976,493113,375361,543647,973781,231488,305714,358458,554731,1005940,981906,149906,369700,609044,890252,140181,882858) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002786s ]