SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012218 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012218 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (853804,580159,143912,565515,692251,23289,1007718,834523,416315,537841,757742,736519,893653,792402,127335,3826,79805,702706,854519,999032,831993,510984,776393,74342,635929,115726,202448,471702,328464,455711,42150,359468,529560,1040204,825276,895386,52047,34809,852337,269024,688494,571956,820121,873616,74267,1004735,667581,713702,193261,1019164,290772,216139,591762,678157,80521,895645,603535,697237,8416,687457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001982s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]