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` = 501534 LIMIT 1 [ RunTime:0.000625s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501534 [ RunTime:0.001695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (872325,311382,266285,794777,734485,413063,2705,325990,603727,346527,990747,189786,914967,469844,403087,1046683,961543,289897,918288,600744,418657,269296,943063,606766,1021480,806186,558411,207575,937224,630780,1025010,469517,249426,993525,739147,181582,470064,841086,510903,710712,92384,274658,1038285,353483,687719,986523,930292,557272,91392,763192,857558,796579,464056,358130,213968,856641,317316,436005,778645,505066) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]