SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001706s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 706817 LIMIT 1 [ RunTime:0.000773s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 706817 [ RunTime:0.001745s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (640396,605995,167562,963138,324410,110451,390846,572427,584887,753364,398342,760456,742163,221460,652722,93047,566660,984120,907601,321032,736914,402450,943077,470678,150490,571540,681882,390552,914873,1001625,207089,22301,754880,484523,340869,723860,638574,1023454,1018078,491239,334378,886861,45638,296862,915514,143951,795735,223271,15367,573675,107963,145623,508211,196542,685705,504202,278251,40486,204430,540730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 706817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 706817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]