SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 590843 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 590843 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (954032,254083,286088,292380,777977,475856,550166,552244,63003,768455,443532,431918,331597,55300,57742,409698,955278,667365,258036,367608,761071,629723,678476,494420,295410,835011,873711,671553,762840,1016668,794421,786789,198361,131294,547417,45581,748516,12648,1003974,756423,361765,55806,501960,61072,222212,941792,862370,875864,460308,895747,212889,7752,363644,11078,255430,528123,133523,485332,11880,614249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002018s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 590843 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000749s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 590843 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001258s ]