SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031561 LIMIT 1 [ RunTime:0.000597s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031561 [ RunTime:0.007810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (303243,300433,687598,639350,612549,579294,176869,107654,334365,566854,50840,974574,785687,987745,151301,488799,787843,831920,639707,244435,180010,577252,268604,330333,393399,420963,626383,373615,742303,866211,776244,76285,900413,591302,288468,441789,336282,619907,1029300,709803,85024,528409,359303,202408,1010468,791620,276363,309074,307067,814311,178121,545935,528963,794919,842781,875344,567041,228681,160833,584874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031561 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031561 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]